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

226 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
frontier114731(None) 
fronter103611581front_er
frontiers1254991frontiers
frostier1148161frostier
bronzier1935632bronzier
flintier1136392flintier
floatier1136982floatier
footier104115112f_ootier
frettier1156592frettier
fringier1236552fringier
froggier1354642froggier
fronted114011272front_ed
frontes104214162front_es
fronting12310442fronting
frontlet1147652frontlet
frontmen1344422frontmen
frother133110152fro_ther
frothier1435952frothier
frouzier2043702frouzier
frowsier1444902frowsier
frowstier1553142frowstier
frowzier2343312frowzier
fruitier1136592fruitier
grottier9316672grottier
groutier9297172groutier
rentier73618222_rentier
rootier74915392_rootier
runtier73512852_runtier
troutier8277152troutier
artier63419733ar__tier
blottier10336413blottier
bonier84321993_bon_ier
bonnier94711313_bonnier
brannier10218933brannier
brattier1047663brattier
brinier93613473brin_ier
bronzer18348493bron_zer
broodier1157433broodier
broomier1236873broomier
brother123311333bro_ther
brownier13226913brownier
coontie9311423coontie_
coonties10513803coonties
cornier93017093corn_ier
cottier93814173_cottier
craftier1376193craftier
crankier14339163crankier
croakier14436273croakier
crofter12299573croft_er
cronies9622513cron_ies
crosier94116583cro_sier
croupier1246893croupier
crozier18369943cro_zier
crustier10259533crustier
daintier937403daintier
dotier73917033_do_tier
dottier83910923_dottier
draftier1285263draftier
driftier1275123driftier
droner74717673dron__er
droolier936073droolier
droopier1145573droopier
drossier956323drossier
drouthier1343033drouthier
drowsier1284913drowsier
fainter103611053faint_er
fancier123412063f_ancier
fattier103513463f_attier
faultier1135283faultier
fawnier13296363fawn_ier
feistier1136193feistier
fennier10339253f_ennier
fernier103110823fern_ier
finnier10319953f_innier
flauntier1243063flauntier
flirtier1144893flirtier
floater104413353float_er
flockier1745343flockier
floppier1554633floppier
flossier11326973flossier
flouncier1442483flouncier
flouter104311343flout_er
flutier103011553f_lutier
flytier13356503f_lytier
foamier12339003f_oamier
foggier12349913f_oggier
folkier14359043f_olkier
fonder104120063f_on_der
fondler11348883f_ondler
fontina1038633f_ontina
footer94320773f_oot_er
footie94718143f_ootie_
footies103721543f_ooties
footler104011873f_ootler
forkier144311593f_orkier
forties104323863f_orties
foster94322223f_ost_er
foxier163910033f_o_xier
fozier183710663f_o_zier
franker143510183fran_ker
frantic12310373franti_c
frater94520593fr_at_er
freakier15246483freakier
frenzied2144043frenzied
frenzies2037713frenzies
fretter103412753fr_etter
frier85225843fr___ier
frillier1136513frillier
friskier1535193friskier
fritter103912773fr_itter
frizzier19284813frizzier
fromenties1546683fromenties
fronded12388863fron_ded
frondeur1242793frondeur
front85029223front___
frontage1296243frontage
frontages13116183frontages
frontal1038363front_al
frontals1146273frontals
frontless1235403frontless
frontlets1244233frontlets
frontline1245053frontline
frontlines1345193frontlines
frontlist1246123frontlist
frontman1344303frontman
fronton1037203front_on
frontons1136503frontons
fronts94415793front__s
frontward1642573frontward
frosted113211883frost_ed
frostiest1239223frostiest
frostily1436693frostily
frosting12311183frosting
frothed14288783fro_thed
frothers14279813fro_thers
frotteur1142503frotteur
frowner13429683fro_wner
fruiter10309683fruit_er
frumpier1534173frumpier
funkier14349983f_unkier
funnier103210173f_unnier
fustier104213933f_ustier
ghostier1235383ghostier
glintier945703glintier
goonier83612843goon_ier
goutier82612353_goutier
granter84117133grant_er
grittier9316263grittier
grodier939673gro_dier
groggier1134343groggier
groovier1233793groovier
grouter84412523grout_er
growlier1234883growlier
growthier1642203growthier
grungier1034983grungier
grunter83110783grunt_er
hootier104915353_hootier
hornier103012463horn_ier
ironer64216453iron__er
ironies7517423iron_ies
jauntier1535233jauntier
joltier14318493_joltier
knottier12203983knottier
kroner104612573kron__er
lintier73613803_lintier
loftier1037763_loftier
loonier73312683loon_ier
mintier93615993_mintier
moonier93714103moon_ier
orangier947713orangier
paintier1048793paintier
phonier122710633phon_ier
plottier10327263plottier
pointier1038303pointier
pornier93413133porn_ier
pottier93516493_pottier
poutier93215323_poutier
prettier1069043prettier
printer93917303print_er
profiter132710203profiter
prosier93817493pro_sier
prostie91617743prostie_
prosties101421193prosties
randier83618473_randier
rangier83714353_rangier
ranter63826823_rant_er
rattier74015593_rattier
renter64527413_rent_er
rentiers83311763_rentiers
rockier134911883_rockier
roilier7311523_roilier
rontgen835173_rontgen
rookier114012383_rookier
roomier93812243_roomier
rooter64926033_root_er
ropier84118813_ro_pier
rosier64221273_ro_sier
roster64329083_rost_er
rotifer1036993_ro_tifer
rotter64325463_ro_tter
roupier9319493_roupier
router65025843_rout_er
rowdier11348593_rowdier
runnier74010113_runnier
rustier74416363_rustier
ruttier73412283_ruttier
scantier10309983scantier
snootier8278383snootier
snottier8217383snottier
snoutier8206973snoutier
sonsier7711743_sonsier
sootier73916613_sootier
spongier1135743spongier
sportier102010053sportier
spottier10207313spottier
stonier72013793ston_ier
tentier73815923_tentier
throatier1244553throatier
tonier65520713_ton_ier
trendier937913trendier
trotter73312253tro_tter
trustier8268683trustier
wonkier1437423_wonkier
wristier1136863wristier
wronger11288823wron_ger
zootier163611173_zootier

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 Filter1786911461620.440406115.9
2DLD Change Limit1461622266.98020940.1
3Display Results2262260.0962354.2
 (SQL Overall)1786912267.51623774.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.