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

234 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
frettier115659(None) 
fretter103412751frett_er
prettier1069041prettier
brattier1047662brattier
fattier103513462f_attier
fetter94120382f_ett_er
freakier15246482freakier
fretted113411852frett_ed
fretters113410302frett_ers
frettiest1267062frettiest
fretting122711522fretting
fritter103912772fritt_er
frontier1147312frontier
frostier1148162frostier
frothier1435952frothier
fruitier1136592fruitier
grittier9316262grittier
grottier9316672grottier
jettier14358692_jettier
nettier74211812_nettier
pettier94213612_pettier
prettied1159252prettied
pretties10615132pretties
rattier74015592_rattier
rentier73618222_rentier
ruttier73412282_ruttier
abetter958323abett_er
artier63419733ar__tier
artsier768943ar_tsier
battier93515713_battier
better84723703_bett_er
bittier94211663_bittier
blottier10336413blottier
breather133610593breather
breathier1435383breathier
breezier1934533breezier
brevier1237763bre_vier
brittler10165983brittler
cattier93317073_cattier
chattier1337513chattier
chertier1387873chertier
chestier1387423chestier
cottier93814173_cottier
craftier1376193craftier
creakier14328333creakier
creamier12319063creamier
creasier103210193creasier
creepier1236253creepier
crepier1139743cre_pier
critter94113033critt_er
crustier10259533crustier
dottier83910923_dottier
draftier1285263draftier
dreamier11287293dreamier
drearier9297923drearier
dreggier1193553dreggier
dressier956863dressier
driftier1275123driftier
erecter93113393erect_er
fatter94523213f_att_er
fatties103018203f_atties
faultier1135283faultier
feater95224053f_eat_er
feather133613503f_eather
featlier1136453featlier
feistier1136193feistier
fennier10339253f_ennier
ferities111416713ferities
fernier103110823f_ernier
fester94723513f_est_er
fetcher153510393f_etcher
fetted104817893f_ett_ed
fetterer11207813f_etterer
fetters103517903f_ett_ers
fetting113517873f_etting
fettle93713123f_ettle_
fettled11378933f_ettled
fettles103912733f_ettles
fierier103511193fie_rier
filthier1434073filthier
fitter94120033f_itt_er
flatter103815963flatt_er
fledgier1333683fledgier
fleecier1334763fleecier
fleeter103210363fleet_er
fleshier1435603fleshier
fletcher16306663fletcher
flextimer2141623flextimer
flintier1136393flintier
flirtier1144893flirtier
flitter103413903flitt_er
floatier1136983floatier
flutier103011553f_lutier
flutter104012093flutt_er
flytier13356503f_lytier
footier104115113f_ootier
forester11313673forest_er
forgetter1345373forgett_er
frater94520593fr_at_er
frecklier1842993frecklier
freebie1236043freebie_
freebies1337873freebies
freer86021243fre___er
freezer19348523fre_ezer
frenzied2144043frenzied
frenzies2037713frenzies
frescoer1345983frescoer
fresher132612643fre_sher
fretty1249223frett__y
frier85225843fr___ier
frillier1136513frillier
fringier1236553fringier
friskier1535193friskier
fritted113611333fritt_ed
fritterer12234403fritterer
fritters113810783fritt_ers
fritting123510703fritting
frizzier19284813frizzier
froggier1354643froggier
fronter103611583front_er
frontiers1254993frontiers
frother133110153fr_other
frotteur1142503frotteur
frouzier2043703frouzier
frowsier1444893frowsier
frowstier1553143frowstier
frowzier2343313frowzier
fruiter10309683fruit_er
frumpier1534173frumpier
fustier104213933f_ustier
getter74117613_gett_er
gleetier934913gleetier
gnattier934263gnattier
greasier9298083greasier
greater84416493great_er
greedier1036083greedier
greenier938713greenier
greeter82812673greet_er
gritter83913353gritt_er
groutier9297173groutier
guttier83911103_guttier
heftier1337203_heftier
jettied15366973_jettied
jetties143613123_jetties
knottier12203983knottier
kreutzer2141273kreutzer
letter63722583_lett_er
meatier93214613_meatier
metier83517693_me_tier
nattier73614623_nattier
netter63722023_nett_er
nettler7349503_nettler
nettlier864813_nettlier
nittier73512243_nittier
nuttier73112023_nuttier
peatier94017233_peatier
pestier94317403_pestier
petter83924773_pett_er
plottier10327263plottier
pottier93516493_pottier
prattler10166343prattler
premier113515633pre_mier
preppier1156643preppier
prester93519623prest_er
prettiest1199803prettiest
prettifier1543973prettifier
prettify1644343prettify
prettily1337283prettily
puttier93314503_puttier
ratter64326313_ratt_er
rattler74012743_rattler
readier83117423_readier
reciter94117263_reciter
reedier83815303_reedier
reefier102912553_reefier
reekier113111123_reekier
reifier103414523_reifier
relier65826183_re_lier
renter64527413_rent_er
rentiers83311763_rentiers
replier94214973_replier
rester63832433_rest_er
retailer82911573_retailer
retainer82913813_retainer
retaker113714313_retaker
retie55735303_re_tie_
retied75924983_re_tied
reties65436193_re_ties
retire64927013_re_tire
retirer74715013_retirer
retried84419153_retried
retries74129073_retries
retted74826313_rett_ed
retting83425883_retting
reutter71010093_reutter
ritter63822423_ritt_er
ritzier16297203_ritzier
rootier74915393_rootier
rotter64325463_rott_er
runtier73512853_runtier
rustier74416363_rustier
scattier10267583scattier
setter64023723_sett_er
settler73410653_settler
shittier1137313shittier
sleetier837883sleetier
slittier837003slittier
sluttier836453sluttier
smuttier1035213smuttier
snottier8217383snottier
spottier10207313spottier
sweatier1147033sweatier
tattier74216243_tattier
tentier73815923_tentier
testier74015643_testier
tetter64322453_tett_er
treater74219833treat_er
treaties8316983treaties
trendier937913trendier
tressier847963tressier
trotter73312253trott_er
troutier8277153troutier
trustier8268683trustier
ureter6313203ure_t_er
vetter93417643_vett_er
wetter93919443_wett_er
whetter13348803whett_er
wittier103910823_wittier
wrathier1435903wrathier
wreather14268603wreather
wrester102812413wrest_er
wrestler11306993wrestler
wristier1136863wristier
zestier163010223_zestier

Search took 9 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.406440125.6
2DLD Change Limit1461622347.82618676.5
3Display Results2342340.0962437.5
 (SQL Overall)1786912348.32821456.7
 
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.