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

140 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
floatels1129566(None) 
floatel10308011floatel_
floaters112711511floaters
bloaters103311022bloaters
boatels93510232_boatels
floated113312702floate_d
floater104413352floate_r
floats96816252float__s
flouters11419272flouters
folates103218452folate_s
gloaters9288862gloaters
alates64833963al_ate_s
bleaters103412323bleaters
bloated104513433bloate_d
bloater94013423bloate_r
bloats85215763bloat__s
blotters104110983blotters
boatel84314093_boatel_
boaters93419243_boaters
botels84815803_bo_tels
brocatels1344193brocatels
clouters10399803clouters
coatees93816553_coatees
coaters93525793_coaters
dottels8327783_dottels
elaters74420193el_aters
elates65032363el_ate_s
eluates72014683eluate_s
falafels1453113falafels
fates85139233f__ate_s
felafels1452853felafels
fellates11312753fellate_s
filiates11412663filiate_s
fixates1737393fixate_s
flails94313003fl_a_ils
flakers143613273fl_akers
flakes134118873fl_ake_s
flamens124611063fl_amens
flamers124616363fl_amers
flames114723693fl_ame_s
flanes94522423fl_ane_s
flannels1134843flannels
flares94521703fl_are_s
flatbeds14364543fl_atbeds
flatlet10312253fl_atlet
flatlets1147373fl_atlets
flatly123110213fl_at_ly
flatness1138153fl_atness
flats86429743fl_at__s
flattens11357483flattens
flatters113814203flatters
flatus94310783fl_at_us
flaxes165015353fl_axe_s
flayers133912033fl_ayers
flirters11337933flirters
flites95122443fl_ite_s
flitters114312173flitters
float85928573float___
floatable1444983floatable
floatage1244403floatage
floatages1344233floatages
floatier1136983floatier
floatiest1237283floatiest
floating123111883floating
floaty124210943float__y
floes85528143flo__e_s
floggers13387863floggers
flokatis1543123flokat_is
flooders12257833flooders
floorers11227573floorers
floppers15337463floppers
florals104210063flo_rals
florets1039853flo_rets
flossers11307863flossers
flosses103411973flosse_s
flotages1237163flotages
flotas94013003flo_t_as
flouted113210813floute_d
flouter104311343floute_r
flouts94315273flout__s
flowages1535733flowage_s
flowers133413173flo_wers
flusters113811503flusters
fluters103713683fl_uters
flutes95421783fl_ute_s
flutters114010823flutters
flytes123911563fl_yte_s
foals85721693f_oa__ls
foamers123812103f_oamers
folate93320393folate__
foliates11412753foliate_s
footers104618333f_ooters
footles103715713f_ootles
fortes95327183f_orte_s
fosters104220103f_osters
fraters103517213f_raters
frontals1146273frontals
frontes104214163fronte_s
frosteds12305653frosteds
gloated93511533gloate_d
gloater83711013gloate_r
gloats74515423gloat__s
goatees82710443_goatees
hostels103712313_hostels
hotels94515513_ho_tels
labels84515683_l_abels
lapels83712043_l_apels
lately93413843_l_ately
latens64620213_l_atens
lintels73311163_lintels
listels74212433_listels
loaders83413433_loaders
loafers10349463_loafers
loaners73913623_loaners
loathers113310443_loathers
loathes103513243_loathes
loathly1334713_loathly
loaves94813853_loave_s
lobately1344013_lobately
locaters102710073_locaters
locates93218813_locate_s
lofters103912903_lofters
loiters74116613_loiters
looters74419163_looters
losels64714583_lo_sels
lotters73921063_lotters
lottes65322753_lotte_s
motels83616893_mo_tels
oaters65029793__oaters
oleates7417833oleate_s
platens94213983pl_atens
platers93924093pl_aters
plates85432243pl_ate_s
pleaters103613793pleaters
plotters104011553plotters
ratels64518213__ratels
slaters73123733sl_aters
slates64934063sl_ate_s
slotters84012403slotters
solates73523853solate_s

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.420425454.8
2DLD Change Limit1461621407.17320376.7
3Display Results1401400.0463043.5
 (SQL Overall)1786911407.63923391.9
 
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.