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

153 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
farce10492532(None) 
face96140121fa_ce
farced125216531farced
farcer115016081farcer
farces115223321farces
farci105919311farci
farcie114816471farcie
farcy135217091farcy
fare76354461far_e
farle86929241farle
force105324271force
ace59656832_a_ce
acre67330772_acre
arc510250902_arc_
arced88224162_arced
arch98628442_arch
arco68331542_arco
arcs67834782_arcs
are37874572_ar_e
arse46539272_arse
barbe95328282barbe
barca91319432barca
barde85330772barde
bare65460522bar_e
barge85631022barge
barre75929542barre
barye105021492barye
brace95629272brace
carcel105018672carcel
care66968372car_e
carle74535702carle
carse74934332carse
carte75940422carte
carve106227752carve
dace76934922da_ce
dance85223132dance
dare55848862dar_e
fable105824752fable
faced117727652fa_ced
facer105525052fa_cer
faces106439432fa_ces
facet106038522fa_cet
fact97142542fa_ct
fade85736342fa_de
fadge104817002fadge
faeces114713122faeces
faerie93514682faerie
fake115534942fa_ke
falces115216002falces
false84818122false
fame95639392fa_me
fancy134615482fancy
fane75343572fa_ne
far67762602far__
farad95720672farad
farcers124713442farcers
farceur12525272farceur
farcies125317882farcies
fard85639062far_d
farded114518952farded
fardel104712592fardel
fards96629842fards
fared95842342fared
farer86733142farer
fares85852872fares
farfel124310432farfel
farl76338552far_l
farles96025782farles
farls85731112farls
farm95934532far_m
farmed125117652farmed
farmer115017372farmer
farms106324952farms
faro76136922far_o
faros85532022faros
fart76860562far_t
farted105121782farted
farts88336842farts
fasces114914542fasces
fate75444282fa_te
fauces114916152fauces
faucet115816552faucet
fauve114712072fauve
fave105532962fa_ve
faze165630042fa_ze
fence105319912fence
fere76342232fer_e
fiacre1137622fiacre
fiance11310742fiance
fice95737112f_ice
fierce11348912fierce
fire76245592fir_e
flare84823632flar_e
forced126316522forced
forcer114917342forcer
forces114422132forces
fore78351472for_e
forge95126942forge
forme105225992forme
forte86131462forte
frae75330472f_rae
frame105821802frame
free75940182f_ree
froe75329992f_roe
furze176815812furze
fyce126316832f_yce
grace85124542grace
hance105424152hance
hare76255732har_e
lace66848472la_ce
lance75126722lance
larch105919792larch
laree56036292laree
large65325462large
mace87345792ma_ce
marc87034632marc_
marcel103714852marcel
march125622892march
marcs95726622marcs
mare64759332mar_e
marge85328332marge
marse76231152marse
nacre75715362nacre
nance74721842nance
narc67127952narc_
narco76718242narco
narcs76122022narcs
pace86345772pa_ce
parae76335702parae
parcel103915472parcel
parch125123002parch
pare66760842par_e
parge85831852parge
parle75836162parle
parse75236992parse
parve109824852parve
race66746262ra_ce
rance75028512rance
rare45348432rar_e
saice75424052saice
saree55044662saree
sarge65531132sarge
sauce75121652sauce
scarce104013632scarce
tace65342512ta_ce
tare45957622tar_e
targe65227092targe
tarre55825632tarre
terce75721842terce
trace75829612trace
varve115716852varve
ware76254722war_e
yare75636942yar_e

Search took 3 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.313570897.8
2DLD Change Limit538001531.64032804.9
3Display Results1531530.0334636.4
 (SQL Overall)1786911531.98689975.3
 
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.