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

268 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
flats8642974(None) 
blats75132501blats
fats76252501f_ats
feats86432751feats
fiats85324481fiats
flabs105818641flabs
flags95321281flags
flams105125011flams
flans85327971flans
flaps105621381flaps
flat77147821flat_
flatus94310781flatus
flaws115920341flaws
flays116321051flays
flits85625221flits
floats96816251floats
frats86829671frats
lats45962701_lats
plats75531371plats
slats55436901slats
alans55636172alans
alants67722022alants
alas46358122ala_s
alate55340332alate
alates64833972alates
alts46639902al_ts
bats66962332_bats
beats76042242beats
blabs95619632blabs
blahs105616512blahs
blams95023852blams
blast76532572blast
blasts85116772blasts
blat66550952blat_
blate75933782blate
blaws105620462blaws
bleats85518612bleats
blets75324942blets
bloats85215762bloats
blots75626172blots
boats75635152boats
brats75336012brats
cats66356342_cats
chats105730092chats
clads85722732clads
clags85621122clags
clams95127672clams
clans75031012clans
claps95626182claps
class75525482class
clast76030582clast
clasts84817292clasts
claws106020832claws
clays105521332clays
cleats84919312cleats
clots75627642clots
coats75635002coats
doats65224882doats
drats66628372drats
eats47054872_eats
eclats8313032eclats
elans55527752elans
elate55335882elate
elates65032362elates
fabs98635862f_abs
facts107021892facts
fads86939872f_ads
fags86939122f_ags
falls85727652falls
fans76247372f_ans
farts88336842farts
fas68262932f_a_s
fast77052312f_ast
fasts86429682fasts
fat68178082f_at_
fate75444282f_ate
fates85139232f_ates
fatso85113492f_atso
fays108535362f_ays
fears84829392fears
feast85932722feast
feasts95116092feasts
feat76458222feat_
felts85324542felts
fests85828042fests
fetas85624402fetas
fets75345942f_ets
fiars86720832fiars
fiat76646642fiat_
filets94718952filets
fists85527542fists
fits76043462f_its
flab96628352fla_b
flack144519412flack
flacks154114532flacks
flag87427082fla_g
flail85316182flail
flails94313002flails
flair86114122flair
flairs95711912flairs
flak116026172fla_k
flake125119972flake
flakes134118872flakes
flaky155715582flaky
flam96333292fla_m
flame105124442flame
flames114723692flames
flamy135217472flamy
flan76134182fla_n
flanes94522422flanes
flank124618092flank
flanks133913402flanks
flap96128702fla_p
flare84823632flare
flares94521702flares
flash115716212flash
flask125512422flask
flasks13488672flasks
flatly123110212flatly
flaunts1056132flaunts
flauta937822flauta
flautas1036152flautas
flaw106326642fla_w
flawy145913382flawy
flax147325632fla_x
flaxes165015352flaxes
flaxy189012292flaxy
flay106332802fla_y
fleams115011942fleams
fleas86423662fleas
flees85828752flees
fleets96915062fleets
flews115316442flews
fleys117015602fleys
flics105418362flics
flies85630712flies
flints95617452flints
flips105117742flips
flirs85518932flirs
flirts95411482flirts
flit76539272flit_
flite85424962flite
flites95122442flites
float85928572float_
floaty124210942floaty
flocs105519232flocs
floes85528142floes
flogs95919962flogs
flops105920142flops
floss85118262floss
flota85315642flota
flotas94013002flotas
flouts94315272flouts
flows115822362flows
flubs105515442flubs
flues84626922flues
flus75626542fl_us
flute86823752flute
flutes95421782flutes
fluty114415642fluty
fluyts12367152fluyts
flyte115713942flyte
flytes123911562flytes
foals85721692foals
foams105017952foams
folate93320392folate
folates103218452folates
fonts86124752fonts
foots85528282foots
forts86034452forts
frags96322172frags
fraps105620552fraps
frass85321122frass
frat75648542frat_
frays116920102frays
frets85523402frets
frits86129102frits
gats56753442_gats
ghats95818612ghats
glads75620612glads
glams85822932glams
glans65125832glans
glass65518132glass
gloats74515422gloats
gluts66120132gluts
gnats65217712gnats
goats65527302goats
halts85230102halts
hats76858252_hats
heats85838402heats
ikats95311152ikats
kats85944332_kats
khats125316012khats
kyats125012442kyats
labs67145122_labs
lacs66942482_lacs
lads56549132_lads
lags56546222_lags
lams66552262_lams
laps66848872_laps
lars46956572_lars
las37281472_la_s
lass47444542_lass
last46260322_last
lasts57731262_lasts
lat37593402_lat_
late47560482_late
lath76640382_lath
laths86022402_laths
lati46438272_lati
latu47934182_latu
lavs76734152_lavs
laws76441682_laws
lays76043252_lays
lets47147942_lets
lits46252492_lits
lots47652092_lots
malts76331752malts
mats65460292_mats
meats75034052meats
moats75827642moats
neats55931902neats
oats46554212_oats
pats66460852_pats
peats76140192peats
plaits83816472plaits
plans75731272plans
plants84921802plants
plat66048872plat_
plate74635112plate
plates85432242plates
platy105021662platy
platys11459852platys
plays106320772plays
pleats85218592pleats
plots75025672plots
prats76333392prats
qats135331342_qats
rats46260372_rats
salts55431882salts
scats75930602scats
seats54844342seats
skats94621542skats
slabs75322642slabs
slags66525902slags
slams74927902slams
slants64819082slants
slaps76025712slaps
slat46959022slat_
slate55438282slate
slates64934062slates
slaty86523152slaty
slaws85222712slaws
slays85723682slays
slits56128852slits
slots54830532slots
sluts54523982sluts
spats75031382spats
splats84817302splats
stats55933362stats
swats85726862swats
tats46858132_tats
teats55636812teats
twats86616602twats
ulans54921302ulans
vats76841742_vats
wats77555882_wats
whats117718992whats

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 Filter178691538000.343520965.0
2DLD Change Limit538002681.73630990.8
3Display Results2682680.0932881.7
 (SQL Overall)1786912682.17282270.3
 
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.