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

211 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
floosies11321023(None) 
floosie10378931floosie_
floozies20326951floozies
flossies112810121flossies
bloodies11310162bloodies
flimsies1335782flimsies
flooie93712152floo_ie_
floozie19295462floozie_
floppies1546812floppies
flosses103411972fl_osses
flossie10337442flossie_
flossier11326972flossier
flossiest12296802flossiest
foodies113416752f_oodies
footies103721542f_ooties
footsies1139642footsies
glossies93311252glossies
loobies93814102_loobies
looies65025832_loo_ies
loonies73919542_loonies
looses67328242_loos_es
aldoses8311203aldos_es
argosies939523argosies
biopsies1237383biopsies
bloodied1245973bloodied
bloodier1136823bloodier
bloodiest1236663bloodiest
blooie83913193bloo_ie_
bloomier1275783bloomier
bloomiest1335853bloomiest
blouses94014463blous_es
blousier1055663blousier
blousiest1136313blousiest
blowsier1335063blowsier
blowsiest1435323blowsiest
boobies113718203_boobies
boodies103721443_boodies
boogies103719013_boogies
bookies133819403_bookies
boonies93422483_boonies
booties94124613_booties
bossies94116833_bossies
brookies1459143brookies
chooses125717423choos_es
choosier1337173choosier
choosiest1437323choosiest
closes85425593cl_os_es
colonies103620013colonies
cookies133719273_cookies
coolies93824963_coolies
cooties93725733_cooties
cosies84932153__cosies
dhoolies1246963dhoolies
dhooties1237643dhooties
doobies103915673_doobies
doodies94218773_doodies
doolies83920713_doolies
doozies173812723_doozies
dropsies1138693dropsies
falsies103515013f_alsies
felonies11310993felonies
felonries1246203felonries
flashes133916103fl_ashes
flenses1039473flens_es
fleshes133913273fl_eshes
flies85630713fl___ies
flimsier1344133flimsier
flimsiest1434463flimsiest
floatier1136983floatier
floatiest1237283floatiest
flockier1745343flockier
flockiest1835643flockiest
floes85528143fl_o__es
flooded12307933floo_ded
flooder11258463floo_der
flooders12257833flooders
flooding13238963flooding
floods104511653floo__ds
floodtides15112583floodtides
flooey123910173floo__ey
floorages1364983floorages
floored11268683floo_red
floorer10248073floo_rer
floorers11227573floorers
flooring12259883flooring
floorings13245093floorings
floorless1243793floorless
floors94112353floo__rs
floosy12368153floos__y
floppier1554633floppier
floppiest1654773floppiest
florins10311643fl_orins
florists1138813florists
floruits1145153floruits
floss85118263fl_os__s
flossed11388533fl_ossed
flosser10339693fl_osser
flossers11307863flossers
flossily1434523flossily
flossing12247903flossing
flotages1237163flotages
flotsams1343383flotsams
flounces1335103flounces
flowages1535733flowages
flunkies1536393flunkies
fluorides1345823fluorides
fluorids1245493fluorids
fluorines1247553fluorines
fluorins1137343fluorins
fluorites1257163fluorites
fluoroses1244943fluoros_es
fluorosis1243923fluorosi_s
flurries11188913flurries
flushes134114143fl_ushes
fogies104118063f__ogies
folkies143612253f_olkies
folksier1533533folksier
folksiest1643983folksiest
follies103618943f_ollies
foodie104413843f_oodie_
footie94718143f_ootie_
footier104115113f_ootier
footiest113514913f_ootiest
footles103715713f_ootles
footsie1047653footsie_
foozles19329543f_oozles
forties104323863f_orties
fosses96022083f__osses
fossils10379013f_ossils
frowsier1444893frowsier
frowsiest1535063frowsiest
fucoses12148303fucos_es
glassies94012273glassies
gloomier1135093gloomier
gloomiest1235603gloomiest
glories81915913gl_ories
glosses84014123gl_osses
glossier9358203glossier
glossiest10277943glossiest
goloshes1236253goloshes
goodies93516993_goodies
goonies83618333_goonies
gooses75723053_goos_es
goosier83512563_goosier
goosiest92911823_goosiest
hoodies113419833_hoodies
hookies144017443_hookies
jalousies1643753jalousies
lassies74420103_lassies
lobbies113612463_lobbies
loesses7310033_loesses
lollies73116923_lollies
longies82916553_longies
looie55624243_loo_ie_
loonie64216453_loonie_
loonier73312683_loonier
looniest83313253_looniest
loopier93711193_loopier
loopiest103011313_loopiest
loose56627683_loos_e_
loosed75520893_loos_ed
loosen66615963_loos_en
loosens716310953_loosens
looser65219943_loos_er
loosest75811563_loos_est
loosing83515963_loosing
lories64933043_l_ories
lorises73918593_lorises
lorries74518343_lorries
loses56742013_l_os_es
losses65925233_l_osses
lotoses73713643_lotos_es
louies64525103_l_ouies
louses66230283_lous_es
lousier72411623_lousier
lousiest82311613_lousiest
noogies82814583_noogies
nookies113414963_nookies
nooses65623643_noos_es
ologies8615023ol_ogies
oologies9312993oologies
ploidies1138173ploidies
plosives1335893pl_osives
plotties103111413plotties
poesies93217403_poesies
popsies112816463_popsies
posies84431433__posies
potsies93019483_potsies
prossies101515223prossies
roofies103014413_roofies
rookies113917103_rookies
roomies93017243_roomies
rooses65526233_roos_es
sloshes103811803sl_oshes
smooshes13206863smooshes
spoonies101911753spoonies
stoolies8311083stoolies
swooshes14185123swooshes
toonies73719883_toonies
tootsies848613tootsies
twoonies1155693twoonies
ufologies1345983ufologies
unlooses8127293unloos_es
whoopies16267373whoopies
whooshes1734423whooshes
whoosis1335453whoosi_s
whoosises1543423whoosises
woodies113517153_woodies
woolies104117363_woolies
wooshes13169883_wooshes
zloties1639913zl_oties

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.423422437.4
2DLD Change Limit1461622117.42019698.4
3Display Results2112110.0802637.5
 (SQL Overall)1786912117.92322553.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.