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

114 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
zorilles173612(None) 
zorillas1745481zorillas
zorille1636671zorille_
zorillos1743731zorillos
gorillas946372gorillas
grilles83715022_grilles
morelles10710492morelles
orioles7412992_orioles
rilles64725502__rilles
rouilles837182rouilles
zorilla1646022zorill_a
zorillo1644682zorill_o
zorils153810882zori_l_s
auricles10138333auricles
barillas10310193barillas
borides10515153bori_des
boulles93114123bo_ulles
brailles1039493brailles
bridles104114473_bridles
brillos9369183_brillos
brills84916293_brill_s
carioles10817073carioles
coquilles2044103coquilles
coracles121811163coracles
corbeilles1443813corbeilles
cordelles1248233cordelles
cornicles1368243cornicles
corollas1039213corollas
darioles9710693darioles
doilies84017363do_ilies
dories75232363dori__es
drilled94711673_drilled
driller84311883_driller
drillers9429723_drillers
drills74414203_drill_s
failles102914133_failles
filles94224523__filles
foibles1238853fo_ibles
folles93820473fo__lles
frilled113911603_frilled
friller104111743_friller
frillers11349873_frillers
frills94414223_frill_s
gerbilles1244013gerbilles
girolles935523girolles
glorioles1044263glorioles
gorilla836973gorill_a
grille74315743_grille_
grilled94012833_grilled
griller84513353_griller
grillers93810813_grillers
grills74314803_grill_s
grilses8319153_grilses
homilies132710113homilies
horribles14113973horribles
krills104211283_krill_s
lories64933043lori__es
lorises73918593lori_ses
manilles102312603manilles
milles84526563__milles
mobiles112813123mobi_les
morales93619403mor_ales
morelle91210803morelle_
morellos10136953morellos
motiles93317433moti_les
mouille937843mouille_
norites74018803nori_tes
oracles93212423_oracles
oriels64914623_oriel_s
oriole6814293_oriole_
orles55326213_or__les
perillas10310823perillas
perilled11410113perilled
prilled104713003_prilled
prills84015613_prill_s
rifles94217703__rifles
riles55343643__ri_les
rille55728733__rille_
rilled74525653__rilled
rillet64828853__rillet
rillets74216153__rillets
rills55032713__rill_s
rocailles1144993rocailles
roselles8310713roselles
rouille737493rouille_
shrilled1246863shrilled
shriller1136823shriller
shrillest1245393shrillest
shrills10389933shrill_s
soilless8279033so_illess
sorites73825243sori_tes
tailles72516473_tailles
thrilled1235493thrilled
thriller1165553thriller
thrillers1244473thrillers
thrills10398783thrill_s
toiles63923513to_i_les
tories65435883tori__es
tornillos953693tornillos
tortillas945183tortillas
trifles103814823_trifles
trilled84116313_trilled
triller74215893_triller
trillers83613493_trillers
trills64319853_trill_s
triples94616873_triples
tuilles72411923_tuilles
utricles1037223utricles
varioles11711123varioles
voiles94616443vo_i_les
zills144020783z__ill_s
zonules1647793zo_nules
zoril143916693zori_l__
zoris145320013zori___s

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 Filter1786911461620.410435831.7
2DLD Change Limit1461621146.34323043.0
3Display Results1141140.0462478.3
 (SQL Overall)1786911146.79926282.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.