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 “floats” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

102 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
floats9681625(None) 
bloats85215761bloats
flats86429741fl_ats
float85928571float_
floaty124210941floaty
flotas94013001flotas
flouts94315271flouts
gloats74515421gloats
afloat9315152afloat_
blats75132502bl_ats
bleats85518612bleats
bloat75229922bloat_
blots75626172blo_ts
boats75635152_boats
cleats84919312cleats
cloaks124411262cloaks
cloots85113692cloots
clots75627642clo_ts
clouts87017202clouts
coats75635002_coats
doats65224882_doats
fats76252502f__ats
feats86432752f_eats
fiats85324482f_iats
flabs105818642fl_abs
flags95321282fl_ags
flams105125012fl_ams
flans85327972fl_ans
flaps105621382fl_aps
flat77147822fl_at_
flatus94310782fl_atus
flaws115920342fl_aws
flays116321052fl_ays
fleams115011942fleams
fleas86423662flea_s
fleets96915062fleets
flints95617452flints
flirts95411482flirts
flits85625222fl_its
floated113312702floated
floatel10308012floatel
floatels11295662floatels
floater104413352floater
floaters112711512floaters
flocks154713532flocks
flocs105519232flo_cs
floes85528142flo_es
flogs95919962flo_gs
flokati1443482flokati
flokatis1543122flokatis
flongs105010492flongs
floods104511652floods
floors94112352floors
flops105920142flo_ps
florals104210062florals
floras94715692floras
florets1039852florets
floss85118262flo_ss
flota85315642flo_ta
flours94414052flours
flout86226202flout_
flows115822362flo_ws
fluyts12367152fluyts
flyboats1643862flyboats
foals85721692f_oals
foams105017952f_oams
folate93320392folate
folates103218452folates
fonts86124752f_onts
foots85528282f_oots
forts86034452f_orts
frats86829672f_rats
fronts94415792fronts
frosts94214622frosts
gloams95210662gloams
gloat65427682gloat_
glosts74513812glosts
glouts74414712glouts
goats65527302_goats
groats74816652groats
lats45962702_l_ats
loads65323372_loads
loafs85616992_loafs
loams75619862_loams
loans56026462_loans
loath84918602_loath
lofts85518362_lofts
loots55431422_loots
lotas55926302_lotas
lots47652092_lo_ts
louts56330272_louts
lovats939072_lovats
moats75827642_moats
oats46554212__oats
plats75531372pl_ats
pleats85218592pleats
plots75025672plo_ts
refloats1156912refloats
shoats94117082shoats
slats55436902sl_ats
slots54830532slo_ts
stoats65117482stoats

Search took 3 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 Filter178691825510.373479064.3
2DLD Change Limit825511022.15638289.0
3Display Results1021020.0303400.0
 (SQL Overall)1786911022.55969828.4
 
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.