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

130 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
zorille163667(None) 
zorilla1646021zorilla
zorilles1736121zorilles
zorillo1644681zorillo
gorilla836972gorilla
grille74315742_grille
morelle91210802morelle
mouille937842mouille
oriole6814292_oriole
rille55728732__rille
rouille737492rouille
zoril143916692zori_l_
zorillas1745482zorillas
zorillos1743732zorillos
zorils153810882zori_ls
auricle9139813auricle
barilla9310323barilla
boride9415903bori_de
boulle84614613bo_ulle
braille939713braille
bridle94115463_bridle
brill74819953_brill_
brillo84211003_brillo
brills84916293_brills
cariole9818343cariole
coquille1944033coquille
coracle112011723coracle
corbeille1344023corbeille
cordelle1148433cordelle
cornicle1258783cornicle
corolla938623corolla
dariole8711163dariole
docile94213123doci_le
drill64718263_drill_
drilled94711673_drilled
driller84311883_driller
drills74414203_drills
faille93414743_faille
fille84327403__fille
foible11410383fo_ible
forcible1545143forcible
frill84917563_frill_
frilled113911603_frilled
friller104111743_friller
frills94414223_frills
frilly124111443_frilly
gerbille1144613gerbille
girolle835793girolle
gloriole944303gloriole
gorillas946373gorillas
gorily10612503gori_ly
grill64617893_grill_
grilled94012833_grilled
griller84513353_griller
grilles83715023_grilles
grills74314803_grills
grilse7399503_grilse
horrible13135233horrible
krill94213643_krill_
krills104211283_krills
loricae938253loricae
manille92613273manille
mille75029133__mille
mobile103613543mobi_le
morale85220553mor_ale
morally12411493morally
morbilli1244963morbilli
morelles10710493morelles
morello9117793morello
morulae958963morulae
motile83818343moti_le
norite63221133nori_te
novelle1058233novelle
oorie53026363oori__e
oracle84313293_oracle
orally93113593_orally
oriel54920423_oriel_
oriels64914623_oriels
orioles7412993_orioles
orle45630463_or__le
perilla9311233perilla
perilled11410113perilled
prill74117943_prill_
prilled104713003_prilled
prills84015613_prills
rifle85518333__rifle
rile45650533__ri_le
rill45140903__rill_
rilled74525653__rilled
rilles64725503__rilles
rillet64828853__rillet
rills55032713__rills
rocaille1045383rocaille
roselle7310243roselle
rouilles837183rouilles
shrill94712303shrill_
shrilled1246863shrilled
shriller1136823shriller
shrills10389933shrills
shrilly13318563shrilly
taille63116923_taille
thrill94910593thrill_
thrilled1235493thrilled
thriller1165553thriller
thrills10398783thrills
toile54626493to_i_le
tornillo854623tornillo
tortile7313193tortile
tortilla845893tortilla
torulae758553torulae
trifle94012883_trifle
trill55122933_trill_
trilled84116313_trilled
triller74215893_triller
trills64319853_trills
triple84215923_triple
tuille63012643_tuille
utricle937913utricle
variole10711593variole
virile9313433viri_le
voile84719723vo_i_le
zill135727613z__ill_
zills144020783z__ills
zoarial1646923zoarial_
zonally1938003zonally
zonulae1645963zonulae
zonule1577483zo_nule
zori137722923zori___
zoris145320013zori__s
zowie174313843zowi__e

Search took 10 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.390458182.1
2DLD Change Limit1340271308.59315597.2
3Display Results1301300.0462826.1
 (SQL Overall)1786911309.02919790.8
 
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.