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

169 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
farces11522332(None) 
faces106439431fa_ces
faeces114713121faeces
falces115216001falces
farce104925321farce_
farced125216531farced
farcer115016081farcer
farcers124713441farcers
farcies125317881farcies
fares85852871far_es
farles96025781farles
fasces114914541fasces
fauces114916151fauces
forces114422131forces
aces67645092_a_ces
acres76327762_acres
arced88224162_arced
arches114822042_arches
arcs67834782_arc_s
arcus76918862_arcus
ares45871022_ar_es
arles56735742_arles
arses55733872_arses
barbes104526232barbes
barcas101016602barcas
bardes95026932bardes
bares75457132bar_es
barges94528252barges
barres84427542barres
baryes116218502baryes
braces108427772braces
calces104420052calces
carcel105018672carcel
carcels114516062carcels
cares77369182car_es
carices114220952carices
caries85147622caries
carles85435082carles
carses85233652carses
cartes86239472cartes
carves115128452carves
daces85030682da_ces
dances95120652dances
dares66146702dar_es
fables114921672fables
face96140122fa_ce_
faced117727652fa_ced
facer105525052fa_cer
facers115519442fa_cers
facet106038522fa_cet
facets116316652fa_cets
facies113921592facies
facts107021892fa_cts
fades94932862fa_des
fadges114814032fadges
faeries104118992faeries
fairies103516042fairies
fakes126032482fa_kes
fames105735922fa_mes
fancies124018782fancies
fanes84639892fa_nes
farads104713272farads
farceur12525272farceur
farceurs13464722farceurs
farci105919312farc_i
farcie114816472farcie
farcy135217092farc_y
farded114518952farded
fardel104712592fardel
fardels11389892fardels
fards96629842far_ds
fare76354462far_e_
fared95842342far_ed
farer86733142far_er
farers95924052farers
farfel124310432farfel
farfels13348212farfels
farle86929242farle_
farls85731112far_ls
farmed125117652farmed
farmer115017372farmer
farmers124315262farmers
farms106324952far_ms
farness102912202farness
faros85532022far_os
farted105121782farted
farts88336842far_ts
fashes124524022fashes
fates85139232fa_tes
faucet115816552faucet
faucets12578442faucets
fauves125610422fauves
faves115331422fa_ves
faxes155726652fa_xes
fazes175527212fa_zes
feces105625362f_eces
fences114617112fences
feres86038182fer_es
fiacres1237252fiacres
fiances12310672fiances
fices106031162f_ices
fires85740752fir_es
flares94521702flar_es
force105324272force_
forced126316522forced
forceps14466982forceps
forcer114917342forcer
forcers124215712forcers
fores85847102for_es
forges105024262forges
formes114623712formes
fortes95327182fortes
fracas11311992fracas
frames115119862frames
frees86131392f_rees
fries85535602f_ries
froes86126692f_roes
furies95126372furies
furzes186613692furzes
fyces139813642f_yces
graces94523492graces
hances115621282hances
hares86255542har_es
laces76141762la_ces
lances84824102lances
larches124416442larches
larees65323112larees
lares54852632lar_es
larges74824232larges
maces97139962ma_ces
marcel103714852marcel
marcels113212372marcels
marches143921172marches
marcs95726622marc_s
mares76457632mar_es
marges94525712marges
marses84827112marses
merces105720742merces
nacres85614452nacres
nances83618642nances
narcos86714202narcos
narcs76122022narc_s
nares55544152nar_es
paces96741112pa_ces
parcel103915472parcel
parcels113712662parcels
parches143720002parches
pares77164482par_es
parges94529542parges
paries84742512paries
parles86334402parles
parses85534702parses
races74943242ra_ces
rances84625442rances
rares55247442rar_es
saices84221802saices
sarees65329942sarees
sarges75128592sarges
sauces84919502sauces
taces76237802ta_ces
tares57456562tar_es
targes74524592targes
tarres64723042tarres
terces83921412terces
traces85329932traces
varices123313572varices
varies94330872varies
varves124414782varves
wares88250582war_es

Search took 4 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 Filter178691825510.343520965.0
2DLD Change Limit825511692.70330540.5
3Display Results1691690.0463673.9
 (SQL Overall)1786911693.09257791.4
 
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.