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 “envious” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

136 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
envious103722(None) 
anxious1437282anxious
devious1138522devious
enginous946492enginous
enviers1036992enviers
envies9314052envi_es
enviously1545892enviously
environs1144672environs
enviros1034912enviros
envois988702env_ois
envoys1255132env_oys
obvious1244822obvious
pervious1337542pervious
unenvious1263242unenvious
aeneous739893aen_eous
anginous947643anginous
animus84211613an_imus
anions64123033an_ions
anurous7311553anurous
anvils9219713anvi_ls
avions94114393_avions
bilious9310933bilious
carious93320283carious
copious11311963copious
curious93813563curious
dubious1036893dubious
echinus1236203echinus
edacious1146023edacious
emulous937343emulous
enamors939123enamors
enamour945433enamour
enamours1044663enamours
enations83316903enations
encinas938723encinas
endings92910443endings
endites83717063endites
endives113710693endives
endows104610423en_dows
engilds974863engilds
engines81114463engines
engirds995053engirds
engross837123engross
enjoins1457333enjoins
enjoys1644603en_joys
enlists749393enlists
enols54718403en__ols
enormous1046553enormous
enows85115493en__ows
enrols61213383en_rols
enroots738713enroots
ensigns836353ensigns
ensiles72714833ensiles
ensoul638253en_soul
ensouls736033en_souls
entices91616333entices
entires71517783entires
entoils7810733entoils
envelops1343493envelops
envenoms1343853envenoms
envied1038833envi_ed
envier939673envi_er
enviro936303envi_ro
environ1044763environ
envisions1245613envisions
envoi878023env_o_i
envoy1156713env_o_y
enwinds11255553enwinds
ervils948773ervi_ls
estrous7712533estrous
ethions1038483ethions
euripus934623euripus
evicts11368553e_victs
evils84114263e_vi_ls
evites94916473e_vites
eximious1743873eximious
folious103710733folious
furious103110633furious
generous939773generous
genius74512923gen_i_us
haviors1347383haviors
haviour1354823haviour
haviours1443843haviours
impious1137063impious
inions64417003in_ions
invidious1343433invidious
invites103915813invites
mentions10312893mentions
nairus639143_nairus
nervous1037143nervous
nevus84611393nev__us
nidus65913573_n_idus
nimious937663nimious
nisus56014393_n_isus
niveous1037193niveous
nodous7711333_nodous
nous46136983_n__ous
noxious1446563noxious
odious749933_odious
onerous7312973onerous
onions64016433on_ions
osmious936003osmious
paviors1237603paviors
paviour1244623paviour
paviours1343613paviours
pensions10311693pensions
penurious1145823penurious
pious74621273__pious
pluvious1344443pluvious
previous1337823previous
renvois1036503renv_ois
reovirus1143423reovirus
rubious938283rubious
sanious7514103sanious
saviors1058993saviors
saviour1035213saviour
saviours1154273saviours
seniors73413613sen_iors
sensuous845903sensuous
serious73616283serious
simious939803simious
tedious838443tedious
tenacious1146423tenacious
tendinous1044623tendinous
tensions8310223tensions
tenuous738483ten_uous
uncinus937403uncinus
unions64216753un_ions
uveous936603_uveous
various103113103various
venomous1345163venomous
venous93713193ven__ous
venulous1145713venulous
vicious1239493vicious
vinous93914173__vinous
viols86118103__viols
virus85316843__virus

Search took 8 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.1561145455.1
2DLD Change Limit1340271366.84319586.0
3Display Results1361360.0462956.5
 (SQL Overall)1786911367.04525364.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.