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

223 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
fiats8532448(None) 
fats76252501f_ats
feats86432751feats
fiars86720831fiars
fiat76646641fiat_
fists85527541fists
fits76043461fi_ts
flats86429741flats
frats86829671frats
airts55626342airts
aits46355532ai_ts
baits76630582baits
bats66962332_bats
beats76042242beats
bias64738162bia_s
bints76130182bints
bits66148162bi_ts
bitts75022592bitts
blats75132502blats
boats75635152boats
brats75336012brats
cats66356342_cats
chats105730092chats
cists76624532cists
coats75635002coats
dials64925342dials
diets66026642diets
dints67431312dints
dirts66824462dirts
ditas65923672ditas
dits56450522di_ts
doats65224882doats
drats66628372drats
eats47054872_eats
fabs98635862f_abs
facts107021892facts
fads86939872f_ads
fags86939122f_ags
fails85631482fails
faints94818782faints
fairs85825442fairs
faith115620852faith
faiths124610272faiths
fans76247372f_ans
farts88336842farts
fas68262932f_a_s
fast77052312f_ast
fasts86429682fasts
fat68178082f_at_
fate75444282f_ate
fates85139232f_ates
fatso85113492f_atso
fays108535362f_ays
fears84829392fears
feast85932722feast
feasts95116092feasts
feat76458222feat_
feints94813872feints
feists94915312feists
felts85324542felts
fests85828042fests
fetas85624402fetas
fets75345942f_ets
fiar76427332fia_r
fibs96329502fi_bs
fices106031162fices
ficus105015492ficus
fidos95819052fidos
fids87034742fi_ds
fiefs116213702fiefs
fifes114822392fifes
fifth145210922fifth
fifths15406542fifths
fifty145211422fifty
fights133816552fights
figs85332642fi_gs
files85441272files
filets94718952filets
fills84632372fills
films105617962films
filos86125382filos
fils75838692fi_ls
filth115015822filth
filths12389782filths
finals94316162finals
finds95424822finds
fines86644262fines
finis86824262finis
finks125424222finks
finos86226952finos
fins75849092fi_ns
fires85740752fires
firms105217422firms
firns86018542firns
firs76637712fi_rs
first86226122first
firsts95110922firsts
firth115819532firth
firths125113502firths
fiscs105311882fiscs
fist76248422fist_
fit66365452fi_t_
fives116027362fives
fixate1638732fixate
fixates1737392fixates
fixes154723592fixes
fixt1410729712fixt_
flabs105818642flabs
flags95321282flags
flams105125012flams
flans85327972flans
flaps105621382flaps
flat77147822flat_
flatus94310782flatus
flaws115920342flaws
flays116321052flays
flints95617452flints
flirts95411482flirts
flits85625222flits
floats96816252floats
foals85721692foals
foams105017952foams
foists95413982foists
fonts86124752fonts
foots85528282foots
forts86034452forts
frags96322172frags
fraps105620552fraps
frass85321122frass
frat75648542frat_
frays116920102frays
frets85523402frets
friars93812092friars
frits86129102frits
fritts94613192fritts
gaits65726012gaits
gats56753442_gats
ghats95818612ghats
giants74713502giants
gifts96214962gifts
gilts64924262gilts
girts65423622girts
gists66026192gists
gits55744592gi_ts
gnats65217712gnats
goats65527302goats
hats76858252_hats
heats85838402heats
hiatus938222hiatus
hilts86924412hilts
hints87330622hints
hists86328372hists
hits75545132hi_ts
ikats95311152ikats
its35538832_i_ts
jilts124717412jilts
kats85944332_kats
khats125316012khats
kilts95122182kilts
kists95822112kists
kits86441772ki_ts
kyats125012442kyats
lats45962702_lats
liars54723162liars
lifts85719062lifts
lilts55822802lilts
lints57137192lints
lists56628692lists
litas54923772litas
lits46252492li_ts
mats65460292_mats
meats75034052meats
milts75430712milts
mints76834042mints
mists76633902mists
mitts75523752mitts
moats75827642moats
neats55931902neats
nits45741642ni_ts
oats46554212_oats
pats66460852_pats
peats76140192peats
pians75126962pians
pias66542552pia_s
pints75936222pints
pitas77427672pitas
pits66348742pi_ts
plats75531372plats
prats76333392prats
qats135331342_qats
rats46260372_rats
rials55026672rials
rias45540592ria_s
riata54618022riata
riatas63915092riatas
rifts85718642rifts
riots54922012riots
scats75930602scats
seats54844342seats
sials54227242sials
sifts84918922sifts
silts55330822silts
sits45050202si_ts
skats94621542skats
slats55436902slats
spats75031382spats
stats55933362stats
swats85726862swats
tats46858132_tats
teats55636812teats
tilts55325612tilts
tints56030922tints
tits46145042ti_ts
twats86616602twats
vats76841742_vats
vials85822382vials
waits88333522waits
wats77555882_wats
whats117718992whats
wilts85023502wilts
wists86728522wists
wits76044872wi_ts
zits136030292zi_ts

Search took 7 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.610292936.1
2DLD Change Limit538002235.5009781.8
3Display Results2232230.0633539.7
 (SQL Overall)1786912236.17328947.2
 
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.