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

147 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
mouille93784(None) 
rouille737491rouille
boulle84614612bou_lle
coquille1944032coquille
manille92613272manille
mille75029132m__ille
mobile103613542mobi_le
morelle91210802morelle
motile83818342moti_le
rouilles837182rouilles
tuille63012642_tuille
zorille1636672zorille
aiguille943303aiguille
andouille1052663andouille
boucle103712783bou_cle
bouillon1043783bouillon
boule74828043bou__le
boulles93114123bou_lles
braille939713braille
coquilles2044093coquilles
coulee8323503cou_lee
couple104415963cou_ple
docile94213123doci_le
double94013993dou_ble
faille93414743_faille
fille84327403__fille
foible11410383fo_ible
foully1239013fou_lly
gorilla836973gorilla
grille74315743_grille
guile64521133_gui_le
joule124918203jou__le
louie55023513loui__e
maile75232223m_ai_le
maill74420793m_aill_
maills84215283m_aills
manilla93012473manilla
manilles102312593manilles
maniple11249653maniple
maxilla16248193maxilla
maxillae17256723maxillae
megilla1036273megilla
meikle1236653m_eikle
micelle1178343micelle
mile66352573m__i_le
mill66541483m__ill_
milled94326173m__illed
miller84625413m__iller
milles84526563m__illes
millet84030743m__illet
mills75435053m__ills
mixible18195093mixible
mobiles112813123mobiles
mobilise1248143mobilise
mobilize2158023mobilize
modally1338393modally
modelled1236423modelled
modeller1136613modeller
modioli1045473modioli
modiste1039283modiste
module93011033mo_dule
moil65534093mo_i_l_
moiled94318863mo_iled
moiler84017263mo_iler
moils76125753mo_i_ls
moire71017323mo_i_re
mole66251833mo___le
moline84422033moli_ne
moll66735703mo__ll_
mollie83517103mo_llie
molls75129783mo__lls
molly105222493mo__lly
monie75631653moni__e
monocle1139663monocle
morale85220553mo_rale
morally12411493morally
morbilli1244963morbilli
morelles10710493morelles
morello9117793morello
morulae958963morulae
motiles93317433motiles
motive113112143moti_ve
mottle84116053mo_ttle
moue65835573mou___e
mouflon12104083mouflon
moulage1037903moulage
mould86015753mou__ld
moulded11348063mou_lded
moulder10389803mou_lder
moulds94910993mou_lds
mouldy12437413mou_ldy
moulin8313283mou_lin
moulins9312703moulins
moult74728723mou__lt
moulted103310313mou_lted
moulter93812423mou_lter
moults84713703mou_lts
mouse77133003mou__se
mousily1239393mousily
mousse84813033mou_sse
movable14189433movable
movie105319133movi__e
moviola1244823moviola
moxie144018123moxi__e
muckle143413583m_uckle
muddle103414633m_uddle
muffle14339643m_uffle
mule65236973m_u__le
mull65128803m_u_ll_
mulla74317113m_u_lla
mulled94721553m_u_lled
mullen83714763m_u_llen
muller83820353m_u_ller
mullet84126823m_u_llet
mulley114013453m_u_lley
mulls75124153m_u_lls
mumble123614343m_umble
muscle10310973m_uscle
mutule8311423m_utule
muzzle16319393m_uzzle
nouvelle1143913nouvelle
novelle1058233novelle
oriole6814293_oriole
outlie62419523_outlie
quill148413763_quill_
quilled17329283_quilled
quillet162713233_quillet
quills153811843_quills
rille55728733__rille
rocaille1045373rocaille
roselle7310243roselle
rouble83913313rou_ble
souffle13306793souffle
squill1537223squill_
squilla1635523squilla
squillae1745183squillae
squills1666303squills
taille63116923_taille
toile54626493to_i_le
tousle64514653tou_sle
touzle15429003tou_zle
tuilles72411923_tuilles
tulle54019933_tu_lle
voile84719723vo_i_le
zorilla1646023zorilla
zorilles1736123zorilles
zorillo1644683zorillo

Search took 9 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.1431249587.4
2DLD Change Limit1340271478.21616312.9
3Display Results1471470.0463195.7
 (SQL Overall)1786911478.40521260.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.