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

129 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
folksier153353(None) 
folkier14359041folk_ier
flossier11326972flossier
folkie13369612folk_ie_
folkies143612252folk_ies
folksiest1643982folksiest
folksily1843442folksily
folksinger1851262folksinger
forkier144311592fork_ier
yolkier14336122yolk_ier
balkier134111983balk_ier
ballsier1036523ballsier
blousier1055663blousier
blowsier1335063blowsier
bolster93713423bol_ster
boskier13309173bosk_ier
bossier93712423bo_ssier
bulkier134111513bulk_ier
cockier154013623cock_ier
collier93618153col_lier
corkier133114303cork_ier
cosier84423753co__sier
dorkier122810023dork_ier
dossier83711693do_ssier
falser93912413fal_s_er
falsie93513853fal_sie_
falsies103515013fal_sies
feldsher1543243feldsher
filister1137403filister
filmier1237503fil_mier
filthier1434073filthier
flakier143910203f_lakier
flamier123112143f_lamier
flasher133914063f_lasher
flashier1437103f_lashier
flawier13378733f_lawier
flaxier17337983f_laxier
flesher133610923f_lesher
fleshier1435603f_leshier
flier86023403f_l__ier
flimsier1344133flimsier
floatier1136983floatier
flockier1745343flockier
floosie10378933floosie_
floosies113210233floosies
floppier1554633floppier
flosser10339693f_losser
flossie10337443flossie_
flossies112810123flossies
flukier14397853f_lukier
flusher133012273f_lusher
fluster103913063f_luster
flutier103011553f_lutier
flytier13356503f_lytier
foamier12339003fo_amier
focuser12155783focus_er
foggier12349913fo_ggier
folder104317543fol__der
foliar93210973fol__iar
folkiest15319503folk_iest
folkish1736563folk_ish
folklife1842963folklife
folklike1434773folklike
folklives1942673folklives
folklore1543473folklore
folks126017123folks___
folksiness1743573folksiness
folksingers1951403folksingers
folksong1642463folksong
folksy16484983folks__y
follies103618943fol_lies
follower14137073follower
foolisher1544223foolisher
footier104115113fo_otier
footsie1047653footsie_
footsies1139643footsies
foreseer1139013foreseer
forester11313673forester
forker134717903fork__er
foster94322223fo__ster
foxier163910033fo__xier
fozier183710663fo__zier
friskier1535193friskier
frowsier1444893frowsier
fubsier12367763f_ubsier
funkier14349983funk_ier
fussier103610673f_ussier
glossier9358203glossier
goosier83512563go_osier
gorsier83811073go_rsier
hokier134214033ho_k_ier
holier94921623hol__ier
holster103512213hol_ster
hookier143811673hook_ier
horsier103013243ho_rsier
hosier94219613ho__sier
hulkier14328973hulk_ier
jokier17618753jo_k_ier
jollier142911003jol_lier
joltier14318493jol_tier
kookier10398283kook_ier
lousier72411623lo_usier
milkier133411163milk_ier
moldier103110033mol_dier
molester1099373molester
mossier94413813mo_ssier
mousier93712463mo_usier
noisier759453no_isier
nonskier1235983nonskier
nosier63716323no__sier
oakier104011393_oak_ier
oldster896573_oldster
osier53518013_o__sier
pockier153911603pock_ier
pokier124914633po_k_ier
polisher1388073polisher
pollster1037103pollster
porkier133712343pork_ier
rockier134911883rock_ier
rookier114012383rook_ier
rosier64221263ro__sier
silkier114411643silk_ier
soldier82812153sol_dier
sonsier7711743so_nsier
sulkier113811963sulk_ier
talkier114011843talk_ier
volkslied1741273volkslied
wonkier1437423wonk_ier
woodsier1245473woodsier

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.403443402.0
2DLD Change Limit1461621297.55019359.2
3Display Results1291290.0462804.3
 (SQL Overall)1786911297.99922339.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.