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

265 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
floatel1030801(None) 
floated113312701floated
floatels11295661floatels
floater104413351floater
bloated104513432bloated
bloater94013422bloater
boatel84314092_boatel
float85928572float__
floaters112711512floaters
floatier1136982floatier
floats96816252float_s
floaty124210942float_y
flouted113210812flouted
flouter104311342flouter
folate93320392folate_
folates103218452folates
gloated93511532gloated
gloater83711012gloater
afloat9315153afloat__
alate55340333al_ate_
alated75625153al_ated
alates64833973al_ates
blate75933783bl_ate_
bleated104015973bleated
bleater94515303bleater
bloat75229923bloat__
bloaters103311023bloaters
bloats85215763bloat_s
blotted103911833blotted
blotter94612853blotter
boated94221973_boated
boatels93510233_boatels
boater84622093_boater
botel75121863_bo_tel
brocatel1246713brocatel
cleated103417853cleated
cloacal1135163cloacal
cloaked14368543cloaked
clotted104011823clotted
clouted104212163clouted
clouter93511693clouter
coated94927043_coated
coatee84327223_coatee
coater84329573_coater
doated84118183_doated
dottel73610893_dottel
elate55335883el_ate_
elated74725823el_ated
elater64724203el_ater
elates65032363el_ates
eluate62315433eluate_
eluates72014683eluates
falafel1383903falafel
falcate12311623falcate_
falcated1438483falcated
fatal84819373f__atal
fate75444283f__ate_
fated95632133f__ated
fates85139233f__ates
feater95224053f_eater
felafel1333723felafel
fellate10313433fellate_
fellated1239563fellated
fellates11312753fellates
filiate10414233filiate_
filiated12610083filiated
filiates11412663filiates
fixate1638733fixate_
fixated1835533fixated
fixates1737393fixates
flail85316183fl_a_il
flake125119973fl_ake_
flaked144715653fl_aked
flaker134916173fl_aker
flakes134118873fl_akes
flakey164410513fl_akey
flame105124443fl_ame_
flamed124618973fl_amed
flamen115215993fl_amen
flamer114919123fl_amer
flames114723693fl_ames
flanes94522423fl_anes
flannel1035423flannel
flare84823633fl_are_
flared105317603fl_ared
flares94521703fl_ares
flat77147823fl_at__
flatbed13397983fl_atbed
flatlet10312253fl_atlet
flatly123110213fl_atly
flats86429743fl_at_s
flatted114012943flatted
flatten10429653flatten
flatter103815963flatter
flatus94310783fl_atus
flawed134712723fl_awed
flaxen16518573fl_axen
flaxes165015353fl_axes
flayed134414053fl_ayed
flayer124713563fl_ayer
fleeted113310233fleeted
fleeter103210363fleeter
flinted114411893flinted
flirted11428673flirted
flirter10318673flirter
flite85424963fl_ite_
flited104616583fl_ited
flites95122443fl_ites
flitted114011643flitted
flitter103413903flitter
floatable1444983floatable
floatage1244403floatage
floatages1344233floatages
floatiest1237293floatiest
floating123111883floating
flocced15365483flocced
flocked174510253flocked
floe76129773flo__e_
floes85528143flo__es
flogged13528803flogged
flogger12449463flogger
flokati1443483flokat_i
flokatis1543123flokatis
flooded12307933flooded
flooder11258463flooder
flooey123910173flo_oey
flooie93712153flooie_
floored11268683floored
floorer10248073floorer
flopped15338763flopped
flopper14328473flopper
florae94713883florae_
floral94313813flo_ral
floreated1346573floreated
floret9321123flo_ret
florets1039853florets
floriated1347023floriated
flossed11388533flossed
flosser10339693flosser
flosses103411973flosses
flota85315643flo_t_a
flotage1136683flotage
flotages1237163flotages
flotas94013003flo_tas
floured11289873floured
flout86226203flout__
flouters11419273flouters
flouts94315273flout_s
flowage1435723flowage_
flowages1535733flowages
flowed133513763flo_wed
flower124815503flo_wer
fluster103913063fluster
flute86823753fl_ute_
fluted104917163fl_uted
fluter95316863fl_uter
flutes95421783fl_utes
flutey125212523fl_utey
flutter104012093flutter
flyable15307123flyable
flyte115713943fl_yte_
flyted13378773fl_yted
flytes123911563fl_ytes
foal76630923f_oa__l
foaled104515963f_oaled
foamed126014403f_oamed
foamer114714313f_oamer
fodgel1136413f_odgel
foetal9311883f_oetal
foliate10513533foliate_
foliated1249913foliated
foliates11412753foliates
fontal9313143f_ontal
footed104418623f_ooted
footer94320773f_ooter
footle93914383f_ootle
forte86131463f_orte_
fortes95327183f_ortes
foster94322223f_oster
frater94520593f_rater
frontal1038363frontal
fronted114011273fronted
fronter103611583fronter
frontes104214163frontes
frosted113211883frosted
gloat65427683gloat__
gloaters9288863gloaters
gloats74515423gloat_s
globate1057823globate_
globated1265753globated
glottal835103glottal
glouted9429713glouted
goatee73219533_goatee
hostel93914153_hostel
hotel85520753_ho_tel
label75019383_l_abel
lapel73716683_l_apel
late47560483_l_ate_
lated65240673_l_ated
lately93413843_l_ately
laten54328343_l_aten
later54843923_l_ater
latex124717113_l_atex
lintel64013993_lintel
listel64214743_listel
loaded84616873_loaded
loader74316313_loader
loafed104011153_loafed
loafer93610943_loafer
loamed94414613_loamed
loaned73816293_loaned
loaner64416503_loaner
loath84918603_loat_h
loathe94211383_loathe
loathed11419443_loathed
loather103711003_loather
loathes103513243_loathes
loathly1334713_loathly
loaves94813853_loaves
lobate82915243_lobate_
lobated102610943_lobated
lobately1344013_lobately
locate83919843_locate_
located103114183_located
locater93113603_locater
locates93218813_locates
lofted103811893_lofted
lofter94614723_lofter
loiter64619173_loiter
looted74421113_looted
looter64222323_looter
losel54419423_lo_sel
lotte54923853_lotte_
lotted74222403_lotted
lotter64025603_lotter
lottes65322753_lottes
louted74920693_louted
moated94819003_moated
motel76623243_mo_tel
oaten55222403__oaten
oater55433733__oater
oleate6318883oleate_
oleates7417833oleates
plate74635113pl_ate_
plated95225773pl_ated
platen84518203pl_aten
plater84427693pl_ater
plates85432243pl_ates
pleated103816633pleated
pleater93916333pleater
plotted104612373plotted
plotter94113663plotter
ratel54224883__ratel
refloated1347013refloated
slate55438283sl_ate_
slated75028313sl_ated
slater64429183sl_ater
slates64934063sl_ates
slatey95417063sl_atey
slotted84613883slotted
slotter73314453slotter
solate64526073solate_
solated83618023solated
solates73523853solates
zlote143912943zlo_te_

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.423422437.4
2DLD Change Limit1340272657.09318895.7
3Display Results2652650.0932849.5
 (SQL Overall)1786912657.60923484.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.