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

275 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
fattily1337946(None) 
cattily123210851cattily
nattily103610321nattily
tattily10409991tattily
artily92814712_artily
chattily1634602chattily
dottily1147282dottily
family143311702fa_mily
fancily1538252fancily
fatally1339892fatally
fatly115716802fa_t_ly
fattier103513462fattier
fatties103018202fatties
fatting113818702fatting
fattish1359262fattish
fatty115117412fatt__y
fatuity1336042fatuity
faultily1474522faultily
fustily133111372fustily
hastily133010662hastily
nastily103011032nastily
nuttily10308632nuttily
pettily1238172pettily
rattly94111542ratt_ly
ruttily10338612ruttily
saltily10310542saltily
tartily103511572tartily
tastily103311642tastily
wittily1336172wittily
aerily93017013_aerily
airily93014823_airily
anticly12410053_anticly
aptly105111813_apt_ly
atilt54828473_a_tilt
attic75618353_atti_c
attics84413283_attics
attire62412383_attire
baggily1436043baggily
balkily16266693balkily
balmily14216463balmily
bastile9313913bastile
battery124911813battery
battier93515713battier
battik1238093batti_k
battiks1337143battiks
batting104422273batting
battle85217863batt_le
batty105422243batt__y
bawdily1635803bawdily
cagily12411563ca_gily
campily1638273campily
cannily1239263cannily
cattail939173cattail_
cattails1038553cattails
cattalo938423cattalo
cattery123811603cattery
cattie85221013catti_e
cattier93317073cattier
catties94023053catties
catting103922643catting
cattish12410723cattish
cattishly1743473cattishly
cattle85118903catt_le
catty104520413catt__y
craftily1644783craftily
daffily1735133daffily
daftly1335443daft_ly
daily95922333da__ily
daintily1245523daintily
dandily12279633dandily
datedly1236023datedly
daylily1434983daylily
dirtily1138583dirtily
draftily1534413draftily
dustily113211523dustily
earthily1445613earthily
earthly13387383earthly
easily9313023ea_sily
emptily1445813emptily
facetely1643853facetely
facile112514883fa_cile
faction122613333faction
factory15108343factory
fadedly1535453fadedly
fail74840243fa__il_
fails85631483fa__ils
faintly1337083faintly
fairly125610013fa_irly
fairy115318283fa__iry
fallibly1644393fallibly
falsely1336013falsely
falsify1643613falsify
falsity1335903falsity
fancify1834983fancify
fantail10310233fantail_
fantails1139693fantails
fantasy1336153fantasy
farting114120753farting
fasting114522833fasting
fatal84819373fa_tal_
fatality1438443fatality
fatbird1344033fatbird
fatherly1745073fatherly
fating105328673fa_ting
fatlike142911193fatlike
fatling113815683fatling
fatted105419843fatt_ed
fatten94314903fatt_en
fattens105111713fattens
fatter94523213fatt_er
fattest102913063fattest
fattiest113514313fattiest
featly123711753feat_ly
feistily1445263feistily
fertile10311733fertile
fetidly1435013fetidly
fetting113517873fetting
fettle93713123fett_le
fictile1238023fictile
fierily1339023fierily
fifthly1943093fifthly
filmily1535733filmily
filthily1743663filthily
fishily1637643fishily
fitly115114973f_it_ly
fitting113516563fitting
fittingly1645263fittingly
flabbily1843353flabbily
flakily1736293flakily
flashily1735473flashily
flatly123110213flat_ly
flattery14338293flattery
flatting123511253flatting
flattish1455263flattish
flauntily1542653flauntily
flintily1434893flintily
flukily1735213flukily
foamily1546543foamily
foggily1535053foggily
fortify1636523fortify
foxily1947253f_oxily
franticly1744013franticly
frostily1436693frostily
frothily1745303frothily
fruitily1445143fruitily
fuggily1534963fuggily
funkily1736513funkily
funnily1336373funnily
furrily1337603furrily
fussily13267603fussily
futile93914953f_utile
fuzzily2145073fuzzily
gaily95020973ga__ily
gamily123712183ga_mily
gassily1137813gassily
gaudily1236523gaudily
gauzily2034393gauzily
gawkily1834093gawkily
goutily1137933goutily
grittily1244183grittily
gustily113010903gustily
gutsily11267223gutsily
hammily1736063hammily
handily143610873handily
happily1745763happily
hardily143310273hardily
hatting113920233hatting
hazily2179063ha_zily
heartily1436563heartily
heftily1635763heftily
jauntily1834173jauntily
jazzily2533373jazzily
joltily1746323joltily
knottily1543153knottily
lacily11612763la_cily
laithly1335653laithly
lankily1437123lankily
lastly93310873last_ly
lately93413843la_tely
latterly1136063latterly
lattice938433lattice
lattin64316223latti_n
lattins74115483lattins
lazily1859713la_zily
loftily1336353loftily
lustily103611243lustily
mangily1339753mangily
manlily1238743manlily
mattedly1443883mattedly
mattery123810713mattery
mattin84416633matti_n
matting103620143matting
mattins93316143mattins
mazily20610393ma_zily
meatily12311093meatily
mistily122612343mistily
mustily123613633mustily
nattier73614623nattier
natty85719143natt__y
nautili746113nautili
nettly9459453nett_ly
niftily1335753niftily
paltrily1345413paltrily
pantile93918483pantile
partly116315473part_ly
pastil85018323pastil_
pastils94416173pastils
patchily1885813patchily
patly105020583pa_t_ly
pattie84020963patti_e
patties93425143patties
patting103722343patting
patty104723613patt__y
pawkily1934203pawkily
pithily1567033pithily
prettily1337273prettily
racily11715173ra_cily
rainily10310433rainily
ramtil8311023ramtil_
ramtils938413ramtils
raptly11338913rapt_ly
ratably121711513ratably
ratify122610043ra_tify
rattail737793rattail_
rattails837133rattails
rattier74015593rattier
ratting83822363ratting
rattish10510823rattish
rattle64717613ratt_le
ratty84819593ratt__y
ritzily1945143ritzily
rustily103112993rustily
sappily1437163sappily
sassily1038723sassily
satiny93817983sa_tiny
saucily1237913saucily
savvily1634323savvily
scantily1337583scantily
smuttily1344273smuttily
snottily1145543snottily
sootily101810513sootily
spottily1335143spottily
squattily2142643squattily
stagily1139053stagily
stately10310223stately
tacitly1236223tacitly
tackily1637503tackily
tactile9310613tactile
tantivy1335563tantivy
tardily11269583tardily
tartly96014023tart_ly
tattie64817513tatti_e
tattier74216243tattier
tatties74120343tatties
tatting84019523tatting
tattle64115653tatt_le
tatty84720183tatt__y
tautly9499503taut_ly
tawnily1335443tawnily
testily102910803testily
tuftily1335573tuftily
vastity1336203vastity
vastly12508723vast_ly
vatting113614853vatting
wackily1936053wackily
warily122915093wa_rily
waspily1535513waspily
waterily1438783waterily
wattle94314213watt_le
wavily15219483wa_vily
waxily19218413wa_xily
wrathily1744773wrathily
yeastily1444573yeastily
zanily18310183za_nily
zestily19167563zestily

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.1561145455.1
2DLD Change Limit1340272757.40618097.1
3Display Results2752750.1102500.0
 (SQL Overall)1786912757.67223291.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.