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

127 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
rouilles83718(None) 
rouille737491rouille_
boulles93114122bou_lles
coquilles2044102coquilles
mouille937842mouille_
rilles64725502r__illes
rocailles1144992rocailles
roselles8310712roselles
roubles93413512rou_bles
tuilles72411922_tuilles
zorilles1736122zorilles
aiguilles1043073aiguilles
andouilles1152413andouilles
boucles113113003bou_cles
bouillon1043783bouillon
bouillons1143603bouillons
boules84925973bou__les
boulle84614613bou_lle_
brailles1039493brailles
coquille1944033coquille_
coulees9315513cou_lees
couples115317053cou_ples
doilies84017363do_ilies
doubles103113353dou_bles
failles102914133_failles
filles94224523__filles
foibles1238853fo_ibles
folles93820473fo__lles
gorillas946373gorillas
grilles83715023_grilles
guiles73919283_gui_les
homilies132710113homilies
hourlies1138343hourlies
joules134116823jou__les
louies64525103loui__es
manilles102312603manilles
milles84526563__milles
mobiles112813123mobi_les
morelles10710493morelles
motiles93317433moti_les
nouvelles1244453nouvelles
orioles7412993_orioles
outlies72421993_outlies
profiles133211233profi_les
quilled17329283_quilled
quillet162713233_quillet
quillets17256823_quillets
quills153811853_quill_s
radicles11249703radicles
ramilies10311833ramilies
ramillies1146133ramillies
rebilled11318053rebilled
rebills93510623rebill_s
refiles104122423refi_les
refilled12278673refilled
refills103711423refill_s
resiles74026543resi_les
reticles103912483reticles
retiles74426993reti_les
retitles83612593retitles
reveilles1245203reveilles
reviles104421353revi_les
rifles94217703r__ifles
riles55343643r__i_les
rille55728733r__ille_
rilled74525653r__illed
rillet64828853r__illet
rillets74216153r__illets
rills55032713r__ill_s
risibles1035783risibles
robles85321693ro__bles
rocaille1045383rocaille_
roiled74320053ro_i_led
roilier7311523ro_ilier
roiliest8312283ro_iliest
roils54826793ro_i_l_s
roles56747983ro___les
rolled74220243ro__lled
roller63919793ro__ller
rollers73117473ro__llers
rolls55326233ro__ll_s
rondelles1046623rondelles
rootles73215633ro_otles
roselle7310243roselle_
rouble83913313rou_ble_
rouches124217893rou_ches
roues56039353rou___es
rouges76022383rou__ges
roughies1298323roughies
roughleg1343403roughleg
roughlegs1442583roughlegs
roulades957173roulades
roundels9217753roundels
roundlet9209223roundlet
roundlets10175293roundlets
rouses65436283rou__ses
routes66129313rou__tes
routines82214363routines
rowelled1236633rowelled
rubbles113715113r_ubbles
rubles83921703r_u_bles
ruckles133414603r_uckles
ruddles92813873r_uddles
ruffles133512273r_uffles
rules55234253r_u__les
rumbles114018393r_umbles
rumples113313133r_umples
rundles83214713r_undles
runkles114111943r_unkles
rustles73416413r_ustles
rutiles74315843r_utiles
soilless8279033so_illess
souffles14298123souffles
soulless8218763sou_lless
squillas1745333squillas
squills1666313squill_s
tailles72516473_tailles
toiles63923513to_i_les
tousles74113933tou_sles
touzles16359223tou_zles
troubles1057203trou_bles
tuille63012643_tuille_
tulles63218893_tu_lles
voiles94616443vo_i_les
zorillas1745483zorillas
zorille1636673zorille_
zorillos1743733zorillos

Search took 8 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.406440125.6
2DLD Change Limit1461621276.56322270.6
3Display Results1271270.0462760.9
 (SQL Overall)1786911277.01525472.7
 
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.