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

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

182 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
rilles6472550(None) 
filles94224521filles
grilles83715021grilles
milles84526561milles
rifles94217701rifles
riles55343641ri_les
rille55728731rille_
rilled74525651rilled
rillet64828851rillet
rillets74216151rillets
rills55032711rill_s
aisles64721142aisles
belles85325992belles
bibles104617642bibles
biles75542142bi_les
bilges94915632bilges
billed94224902billed
biller84923482biller
billers94720832billers
billet86029722billet
billets94516152billets
billies93923502billies
bills75632862bill_s
birles84920642birles
brailles1039492brailles
bridles104114472bridles
brillos9369182brillos
brills84916292brill_s
dalles74222062dalles
dilled84122222dilled
dillies84122162dillies
dills65530972dill_s
drilled94711672drilled
driller84311882driller
drillers9429722drillers
drills74414202drill_s
failles102914132failles
files85441272fi_les
fille84327402fille_
filled104922262filled
filler94623622filler
fillers104320212fillers
fillet95027082fillet
fillets103414752fillets
fillies103420252fillies
fillos94415082fillos
fills84632372fill_s
folles93820472folles
frilled113911602frilled
friller104111742friller
frillers11349872frillers
frills94414222frill_s
gilled84521632gilled
giller74519732giller
gillers84216902gillers
gillies84120962gillies
gills64728192gill_s
grille74315742grille_
grilled94012832grilled
griller84513352griller
grillers93810812grillers
grills74314802grill_s
grilses8319152grilses
hilled104022222hilled
hiller94421632hiller
hillers103718732hillers
hilloes103815962hilloes
hillos94618892hillos
hills85431352hill_s
idles66720122_idles
iller54821292_iller
illest63615722_illest
ills47030422_ill_s
isles54220562_isles
jills125122822jill_s
killed113918772killed
killer104917952killer
killers114215582killers
killies113318112killies
kills94526172kill_s
krills104211282krill_s
lilies63021412lilies
lisles63416282lisles
miles74645072mi_les
mille75029132mille_
milled94326172milled
miller84625412miller
millers93621342millers
millet84030742millet
millets94216842millets
mills75435052mill_s
nilled73919452nilled
nills54926672nill_s
orioles7412992orioles
piles74742612pi_les
pilled94222752pilled
pills74130972pill_s
pilules9510622pilules
prilled104713002prilled
prills84015612prill_s
rales54947492r_ales
rallies73823342rallies
rallyes10348552rallyes
reales64934122reales
relies65036422relies
rials55026672rial_s
ribes75530172ri_bes
ribless93410342ribless
riblet84222442riblet
riblets93412552riblets
rices75536152ri_ces
riches115022082riches
riddles93215022riddles
rides66140812ri_des
ridges85817012ridges
ridley10169542ridley
ridleys11145782ridleys
riels55121332riel_s
riffles133911162riffles
rifle85518332rifle_
rifled104115002rifled
rifler94014262rifler
riflers103512192riflers
rile45650532ri_le_
riled65833252ri_led
riley84420582ri_ley
rill45140902rill__
rimes75634542ri_mes
rimless9369362rimless
rimples113114222rimples
rinses64720382rinses
ripes75435772ri_pes
ripples113513292ripples
rises55244042ri_ses
rites54442552ri_tes
ritzes154812942ritzes
rives85336002ri_ves
robles85321692robles
roles56747982r_oles
rolled74220242rolled
roller63919792roller
rollers73117472rollers
rolls55326232roll_s
rouilles837182rouilles
rubles83921702rubles
rules55234252r_ules
selles64426982selles
sidles74721152sidles
siller64026062siller
sillers73822102sillers
sillies73425082sillies
sills55135992sill_s
tailles72516472tailles
tildes74513962tildes
tiles55542102ti_les
tilled74722952tilled
tiller64222542tiller
tillers73418742tillers
tills54631712till_s
titles63719922titles
trifles103814822trifles
trilled84116312trilled
triller74215892triller
trillers83613492trillers
trills64319852trill_s
triples94616872triples
tuilles72411922tuilles
tulles63218892tulles
villas96117262villas
vills86429322vill_s
villus93611222villus
wiles85437872wi_les
willed104722452willed
willer94021062willer
willers103517912willers
willet95124832willet
willets104414322willets
willies103920152willies
wills84528962will_s
yills83921552yill_s
zills144020782zill_s
zorilles1736122zorilles

Search took 3 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 Filter178691825510.373479064.3
2DLD Change Limit825511822.34335233.0
3Display Results1821820.0632888.9
 (SQL Overall)1786911822.77964300.5
 
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.