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 “enviro” 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.

122 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
enviro93630(None) 
environ1044761environ
enviros1034911enviros
enduro7338622enduro
engird8126972engird
engirt71112612engirt
entire61617702entire
envied1038832envied
envier939672envier
enviers1036992enviers
envies9314052envies
environs1144672environs
andiron848283andiron
andro6314163an_dro
anvil82712603anvi_l
anvils9219713anvils
aviso85713963_aviso
biro66131203__biro
centimo11609543centimo
chiro105320343_chiro
elver85216243elver_
elvers93814983elvers
elvish1277563elvish
emir65918693e_mir_
emirs76116153e_mirs
empire1039313empire
enamor838753enamor
encina8310443encina
encore8314773encore
ender64325863ender_
enders74324053enders
ending83220253ending
endite73817593endite
endive103310473endive
endrin7312403endrin
endure74014143endure
enduros8298153enduros
engild8107613engild
engine71114863engine
engirds995053engirds
enhalo987563enhalo
enlist6417043enlist
enmity1137483enmity
enorm74415633en_orm
enquire16287213enquire
enquiry19254043enquiry
enrich1138943enrich
enrol51014283en__rol
enserf9310763enserf
ensign737523ensign
ensile62616473ensile
ensure63416003ensure
enter54726383enter_
entera64216833entera
enteron7313333enteron
enters64425643enters
entia5318203enti_a
entice81316863entice
entires71517783entires
entity9312053entity
entry82414263en_try
enure53520223en_ure
envelop1243323envelop
envenom1244063envenom
envious1037223envious
environed1342843environed
envision1145953envision
envoi878023env_oi
envois988703envois
envoy1156713env_oy
envoys1255133envoys
envy10411253env__y
envying1435713envying
enwind10298083enwind
ervil8310303ervi_l
ervils948773ervils
euro45325273e__uro
ever77027693e_ver_
evert84929513e_vert
every115215453e_very
evict104417143e_vict
evil75318073e_vi_l
evils84114263e_vils
evite85317683e_vite
expire1538023expire
expiry1834653expiry
eyrir8359653eyrir_
genro64914033gen__ro
giro55828633__giro
guiro63712093_guiro
havior1248203havior
indigo8388013indigo
infirm1137033infirm
inro45920793in__ro
intro54915853in_tro
invar839513invar_
invars9310003invars
invert94120083invert
invite93715023invite
lentigo846063lentigo
mendigo11506333mendigo
menhir1136783menhir_
menhirs1235913menhirs
naira5314743_naira
nairu5413813_nairu
never86218643never_
nevi75116423nevi__
nitro54914353_nitro
noir46722433_noir_
noirs55615463_noirs
pavior1138533pavior
savior9710173savior
senior63214043sen_ior
sentimo9449613sentimo
tiro46832363__tiro
ungird887973ungird
ungirt71112713ungirt
venire93513693ven_ire
vino76128433__vino
vireo84816453__vireo
virl76224473__virl
wendigo12845403wendigo

Search took 6 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 Filter1786911127160.1561145455.1
2DLD Change Limit1127161225.72019705.6
3Display Results1221220.0462652.2
 (SQL Overall)1786911225.92230174.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.