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

169 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
floosie1037893(None) 
flooie93712151floo_ie
floosies113210231floosies
floozie19295461floozie
flossie10337441flossie
blooie83913192bloo_ie
floosy12368152floos_y
floozies20326952floozies
flossier11326972flossier
flossies112810122flossies
foodie104413842f_oodie
footie94718142f_ootie
footsie1047652footsie
looie55624242_loo_ie
loonie64216452_loonie
loose56627682_loos_e
aldose7311093aldos_e
bloodied1245973bloodied
bloodier1136823bloodier
bloodies11310163bloodies
bloomier1275783bloomier
blouse84714723blous_e
blousier1055663blousier
blowsier1335063blowsier
boobie104015293_boobie
boogie93515993_boogie
bookie123516003_bookie
bootie85421163_bootie
brookie1347373brookie
choose115116143choos_e
choosier1337173choosier
close76425223cl_os_e
cookie123716043_cookie
coolie83821603_coolie
cootie84223093_cootie
cosie74728263__cosie
dhootie1136473dhootie
donsie7613643_donsie
doobie94712683_doobie
doolie73916833_doolie
doozie163910653_doozie
falsie93513853f_alsie
filose96112503filos_e
flense938903flens_e
flimsier1344133flimsier
flimsies1335783flimsies
floatier1136983floatier
flocci1335023flocci_
floccose1543133floccos_e
flockier1745343flockier
flocs105519233flocs__
floe76129773fl_o__e
floes85528143floes__
flogs95919963flogs__
flood95215603floo__d
flooded12307933flooded
flooder11258463flooder
flooding13238963flooding
floodlit1244073floodlit
floods104511653floo_ds
floodtide14102483floodtide
flooey123910173floo_ey
floor84215233floo__r
floorage1275093floorage
floored11268683floored
floorer10248073floorer
flooring12259883flooring
floors94112353floo_rs
floozy21356613floo_zy
floppier1554633floppier
floppies1546813floppies
flops105920143flops__
florae94713883fl_orae
florid10311453fl_orid
florin9312653fl_orin
florist10314243florist
floruit1047293floruit
floss85118263fl_os_s
flossed11388533flossed
flosser10339693flosser
flosses103411973flosses
flossiest12296803flossiest
flossily1434523flossily
flossing12247903flossing
flossy12517703fl_ossy
flotage1136683flotage
flotsam1244623flotsam
flounce1235413flounce
flowage1435723flowage
flows115822363flows__
flunkie1434513flunkie
fluoric1245813fluoric
fluorid1136783fluorid
fluoride1245873fluoride
fluorin1037233fluorin
fluorine1147813fluorine
fluorite1147893fluorite
fluorosis1243923fluorosis
fogie96719003f__ogie
foliose10378013folios_e
folkie13369613f_olkie
folksier1533533folksier
foodies113416753f_oodies
footier104115113f_ootier
footies103721543f_ooties
footle93914383f_ootle
footsies1139643footsies
foozle18369203f_oozle
fossae95510373f_ossae
fosse86119463f__osse
fossil9379353f_ossil
frowsier1444893frowsier
fucose11167683fucos_e
glassie8329493glassie
globose1035543globos_e
gloomier1135093gloomier
glossae8477283glossae
glossier9358203glossier
glossies93311253glossies
goloshe1134723goloshe
goodie83613993_goodie
goonie73615563_goonie
goose65925903_goos_e
goosier83512563_goosier
hoodie105116143_hoodie
hoolie93217783_hoolie
jalousie1543143jalousie
kookie9389843_kookie
lassie64917743_lassie
loggie84011993_loggie
loobies93814103_loobies
looies65025833_loo_ies
loonier73312683_loonier
loonies73919543_loonies
loopier93711193_loopier
loos49051123_loos__
loosed75520893_loosed
loosen66615963_loosen
looser65219943_looser
looses67328243_looses
loosing83515963_loosing
lose45144583_l_os_e
louie55023513_l_ouie
louse56131013_lous_e
lousier72411623_lousier
lowse87219903_lows_e
moose76327193_moos_e
noogie73612313_noogie
nookie103712433_nookie
noose55624063_noos_e
oorie53026363__oorie
plosive1236673pl_osive
popsie103013053_popsie
potsie83916033_potsie
prossie91812953prossie
roofie93411173_roofie
rookie103613263_rookie
roomie83013873_roomie
roose56127093_roos_e
sonsie6614863_sonsie
stoolie739723stoolie
toonie63617993_toonie
tootsie737133tootsie
twoonie1034423twoonie
unloose797863unloos_e
whoopie15295933whoopie
whoosis1335453whoosis
woodie103513613_woodie
woolie93514483_woolie

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271696.51620568.9
3Display Results1691690.0632682.5
 (SQL Overall)1786911696.98525582.1
 
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.