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

269 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
floatier113698(None) 
floater104413351float_er
bloater94013422bloat_er
blottier10336412blottier
flakier143910202fl_akier
flamier123112142fl_amier
flatter103815962fl_atter
flawier13378732fl_awier
flaxier17337982fl_axier
flintier1136392flintier
flirtier1144892flirtier
floated113312702float_ed
floatel10308012float_el
floaters112711512float_ers
floatiest1237282floatiest
floating123111882floating
flockier1745342flockier
floppier1554632floppier
flossier11326972flossier
flouter104311342flout_er
flutier103011552fl_utier
flytier13356502fl_ytier
foamier12339002f_oamier
footier104115112f_ootier
frontier1147312frontier
frostier1148162frostier
gloater83711012gloat_er
loamier9349162_loamier
loather103711002_loather
loftier1037762_loftier
platier93716292pl_atier
plottier10327262plottier
slatier74016812sl_atier
blastier10249493blastier
blather125314203bl_ather
blatter94415653bl_atter
blearier1037333blearier
bleater94515303bleat_er
bloated104513433bloat_ed
bloaters103311023bloat_ers
bloating113512813bloating
blockier1666133blockier
bloodier1136823bloodier
bloomier1275783bloomier
blotter94612853blo_tter
blousier1055663blousier
blowier1248943blo_wier
blowsier1335063blowsier
blowzier2233413blowzier
boater84622093_boat_er
clatter94014973cl_atter
clavier1239173cl_avier
clayier1248323cl_ayier
cloddier1234063cloddier
cloggier1244253cloggier
clothier1335363clothier
cloudier1135053cloudier
clouter93511693clout_er
coalier93416183_coalier
coater84329573_coat_er
cottier93814173_cottier
croakier14436263croakier
dotier73917033_do_tier
dottier83910923_dottier
elater64724203el_at_er
father125116713f__ather
fatter94523213f__atter
fattier103513463f_attier
faultier1135283faultier
feater95224053f_eat_er
feather133613503f_eather
featlier1136453f_eatlier
feistier1136193feistier
flabbier1534093flabbier
flagger12469353fl_agger
flaggier13105203flaggier
flair86114123fl_a_i_r
flaker134916173fl_a_ker
flamer114919123fl_a_mer
flanger113412623fl_anger
flanker143911293fl_anker
flapper14359203fl_apper
flappier1544293flappier
flasher133914063fl_asher
flashier1437103flashier
flatbed13397983fl_atbed
flatcar1274613fl_atcar
flatlet10312253fl_atlet
flatliner12285383fl_atliner
flatted114012943fl_atted
flatten10429653fl_atten
flatters113814203fl_atters
flattery14338293fl_attery
flauntier1243063flauntier
flayer124713563fl_a_yer
fledgier1333683fledgier
fleecier1334763fleecier
fleeter103210363fleet_er
fleshier1435603fleshier
flextimer2141623flextimer
flier86023403fl___ier
flightier1644423flightier
flimsier1344133flimsier
flirter10318673flirt_er
flitter103413903fl_itter
float85928573float___
floatage1244403floatage
floatages1344233floatages
floatels11295663floatels
floats96816253float__s
floaty124210943float__y
flogger12449463flo_gger
flokati1443483flokati__
flokatis1543123flokati_s
flooder11258463flo_oder
flooie93712153flo_oie_
floorer10248073flo_orer
floosie10378933floosie_
floosies113210233floosies
floozie19295463floozie_
floozies20326953floozies
flopover1642863flopover
flopper14328473flo_pper
floppies1546813floppies
flosser10339693flo_sser
flossie10337443flossie_
flossies112810123flossies
flotage1136683flotage_
flotages1237163flotages
flotation1267813flotation
flouncier1442483flouncier
flounder1235103flounder
flouted113210813flout_ed
flouters11419273flout_ers
flouting122610473flouting
flower124815503flo__wer
flowerer1435453flowerer
flowerier1544273flowerier
fluffier13264333fluffier
flukier14397853fl_ukier
fluster103913063flust_er
fluter95316863fl_ut_er
flutter104012093fl_utter
flytiers14254483fl_ytiers
foamer114714313f_oa_mer
foggier12349913f_oggier
folate93320393folat_e_
folates103218453folat_es
folkier14359043f_olkier
folksier1533533folksier
footer94320773f_oot_er
footie94718143f_ootie_
footies103721543f_ooties
footler104011873f_ootler
forkier144311593f_orkier
forties104323863f_orties
foster94322223f_ost_er
foxier163910033f_o_xier
fozier183710663f_o_zier
frater94520593f_rat_er
freakier15246483freakier
frettier1156593frettier
froggier1354643froggier
fronter103611583front_er
frontiers1254993frontiers
frother133110153fro_ther
frothier1435953frothier
frouzier2043703frouzier
frowsier1444893frowsier
frowstier1553143frowstier
frowzier2343313frowzier
fruitier1136593fruitier
fustier104213933f_ustier
ghostier1235383ghostier
glacier103911293gl_acier
gladier93810993gl_adier
glarier84112203gl_arier
glazier17409353gl_azier
gleamier1144913gleamier
gleetier934913gleetier
glintier945703glintier
gloated93511533gloat_ed
gloaters9288863gloat_ers
gloating102611463gloating
globbier1334243globbier
gloomier1135093gloomier
gloppier1354673gloppier
glossier9358203glossier
goutier82612353_goutier
grottier9316673grottier
groutier9297173groutier
hoarier104211743_hoarier
hootier104915353_hootier
joltier14318493_joltier
knottier12203983knottier
lacier84020093_l_acier
lakier104716273_l_akier
later54843923_l_at_er
lather95124353_l_ather
lathier10310833_l_athier
latter65027893_l_atter
lazier154214613_l_azier
leadier83212723_leadier
leafier10329833_leafier
leakier114010993_leakier
learier73415663_learier
leather103815783_leather
leavier10319993_leavier
lintier73613803_lintier
loader74316313_loa_der
loafer93610943_loa_fer
loaner64416503_loa_ner
loathe94211383_loathe_
loathed11419443_loathed
loathers113310443_loathers
loathes103513243_loathes
locater93113603_locat_er
lofter94614723_loft_er
loggier93811143_loggier
logier75015733_lo_gier
loiter64619173_loit_er
loonier73312683_loonier
loopier93711193_loopier
looter64222323_loot_er
loppier11369723_loppier
lotter64025603_lo_tter
lousier72411623_lousier
lowlier10338903_lowlier
lustier73813503_lustier
matier84321523__matier
meatier93214613_meatier
oakier104011393__oakier
oater55433733__oat_er
peatier94017233_peatier
plaiter93615393pl_aiter
plater84427693pl_at_er
platies93722543pl_aties
platter93917413pl_atter
pleater93916333pleat_er
pleather1356653pleather
plotter94113663plo_tter
plotties103111413plotties
pottier93516493_pottier
poutier93215323_poutier
rootier74915393_rootier
shoalier1137073shoalier
slater64429183sl_at_er
slather103816073sl_ather
sleazier1735123sleazier
sleetier837883sleetier
slittier837003slittier
slobbier1254633slobbier
sloppier1255703sloppier
sloshier1135283sloshier
slotter73314453slo_tter
sluttier836453sluttier
snootier8278383snootier
snottier8217383snottier
snoutier8206973snoutier
soapier93411713_soapier
sootier73916613_sootier
sportier102010053sportier
spottier10207313spottier
sweatier1147033sweatier
throatier1244553throatier
toastier846893_toastier
troutier8277153troutier
zloties1639913zlo_ties
zootier163611173_zootier

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 Limit1461622696.86021306.4
3Display Results2692690.0932892.5
 (SQL Overall)1786912697.35924282.0
 
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.