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

105 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
eryngo103361(None) 
eringo739551eringo
eryngos1142731eryngos
drongo836792drongo
ergo56420152er__go
eringos836912eringos
erugo6369852er_ugo
eryngoes1242942eryngoes
gringo838642gringo
aerugo735803aer_ugo
bingo86020093_bingo
bongo85720943_bongo
bring85528503bring_
brings94618433brings
bronco10179493bronco
brung84613913brung_
cering94522533cering_
congo85623133_congo
cringe93515483cringe
crying123612283crying_
crypto13367273crypto
derange939813derange
dingo74720793_dingo
drongos935493drongos
drying113411603drying_
earing75235483earing_
earings84517713earings
eggnog941973eggnog
ego46726053e___go
eking106614983eking_
eng46726783e__ng_
engs56121393e__ngs
erenow937373erenow
erg45531073er__g_
ergot65422893er__got
ergs55523813er__gs
eringoes937433eringoes
ern35738363er_n__
erne46727433er_n_e
ernes55224813er_nes
erns45428233er_n_s
erring73816483erring_
erugos7347343er_ugos
exing136016813exing_
eying96117923eying_
eyne76322463e_yn_e
fringe104013953fringe
fringy13309263fringy
frying134511403frying_
fungo94413133_fungo
grange83716203grange
grego7310523gr_ego
gringa838553gringa
gringos936673gringos
grunge8359583grunge
grungy11345973grungy
iring66025423iring_
jingo134615213_jingo
lingo66022113_lingo
mango85724323_mango
marengo1035263marengo
merino8315093merin_o
mongo810122413_mongo
mungo84916053_mungo
olingo736933olingo
orang65119943orang_
orange74016323orange
orangs74116033orangs
orangy105111233orangy
pengo84317593_pengo
pernio8513143per_nio
pingo87122713_pingo
prang84820323prang_
prangs94816233prangs
prong85218113prong_
prongs94314483prongs
pronto8313993pronto
prying124114803prying_
quango1636493quango
rang56939163_rang_
range64728413_range
rangy95320383_rangy
ring56541153_ring_
rings65029173_rings
rondo65218373_rondo
rung56429983_rung_
rungs611819403_rungs
rynd86414103_ryn_d
rynds9569973_rynds
sering74731813sering_
seringa83310743seringa
serpigo1044833serpigo
stingo74212163stingo
tango66921173_tango
trigo65716053tr_igo
trying104214073trying_
vertigo1146133vertigo
wrang94716113wrang_
wrangs104611913wrangs
wring95920713wring_
wrings104012973wrings
wrong94712323wrong_
wrongs10338933wrongs
wrung9549803wrung_
wrying13379623wrying_

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.390458182.1
2DLD Change Limit1127161055.47020606.2
3Display Results1051050.0303500.0
 (SQL Overall)1786911055.89030338.0
 
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.