Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “obvious” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

89 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
obvious124482(None) 
devious1138522devious
envious1037222envious
oblivious1443062oblivious
obviously1744772obviously
odious749932o_dious
osmious936002osmious
anxious1437283anxious
avions94114393_avions
bayous11411153_bayous
bijous1548043_bijous
bilious9310933bilious
biogs85016113_b_iogs
bios66335333_b_io_s
boubous1138693boubous
bovids1287973bovi_ds
bovines12412663bovines
brios74725733_brio_s
carious93320283carious
copious11311963copious
curious93813563curious
dubious1036893dubious
folious103710733folious
furious103110633furious
haviors1347383haviors
haviour1354823haviour
haviours1443843haviours
impious1137063impious
nimious937663nimious
niveous1037193niveous
nonobvious1552623nonobvious
noxious1446563noxious
obelus8348403ob_elus
obias76116863ob_i_as
obiisms1135673obiisms
obis66226843ob_i__s
obits74617553ob_i_ts
obliges1037143obliges
obligors1143523obligors
oblique1844703oblique
obliques1944533obliques
oblivions1443243oblivions
obnoxious1851613obnoxious
oboes75717713ob__oes
oboists937903oboists
obols73715863ob__ols
obolus8378813ob_olus
obverts1235403obverts
obviate1235793obviate
obviates1345173obviates
obviators1444863obviators
ochrous1237943ochrous
odorous837663odorous
olios54520853o_lio_s
ominous949033ominous
omnibus1152983omnibus
onerous7312973onerous
onions64016433o_nions
options93810603options
osmous8138183o_smous
osseous736063osseous
ovibos1145463o_vibos
ovines94614343o_vines
ovoids10456923o_voids
ozonous1645263ozonous
paviors1237613paviors
paviour1244623paviour
paviours1343613paviours
pervious1337543pervious
pious74621273__pious
pluvious1344443pluvious
poxvirus2041883poxvirus
previous1337833previous
rubious938283rubious
sanious7514103sanious
saviors1058993saviors
saviour1035213saviour
saviours1154273saviours
serious73616283serious
simious939803simious
subvirus1344333subvirus
tedious838443tedious
tortious839023tortious
uveous936603_uveous
various103113103various
vicious1239493vicious
vinous93914173__vinous
viols86118103__viols
virus85316843__virus

Search took 7 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911340270.423422437.4
2DLD Change Limit134027896.39020974.5
3Display Results89890.0332697.0
 (SQL Overall)178691896.84626101.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.