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

192 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
farles9602578(None) 
arles56735741_arles
carles85435081carles
fables114921671fables
farces115223321farces
fares85852871far_es
farle86929241farle_
farls85731111farl_s
parles86334401parles
ables75935542_ables
ales47067102_a_les
ares45871022_ar_es
argles75218482_argles
arses55733872_arses
axles125219472_axles
bales76250082ba_les
barbes104526232barbes
bardes95026932bardes
bares75457132bar_es
barges94528252barges
barless94317002barless
barley115116762barley
barleys125011842barleys
barres84427542barres
baryes116218502baryes
birles84920642birles
cables104527552cables
cares77369182car_es
caries85147622caries
carle74535702carle_
carless95118492carless
carls77037422carl_s
carses85233652carses
cartes86239472cartes
carves115128452carves
caules85927252caules
dales66439742da_les
dalles74222062dalles
dares66146702dar_es
darkles124011932darkles
dartles84014132dartles
eagles73819162eagles
earless74316072earless
earls56127512earl_s
fable105824752fable_
fabled124216382fabled
fabler116115812fabler
fablers124812612fablers
faces106439432fa_ces
facies113921592facies
fades94932862fa_des
fadges114814022fadges
faeces114713122faeces
faeries104118992faeries
failed105421602failed
failles102914132failles
fails85631482fail_s
fairies103516042fairies
fakes126032482fa_kes
falces115216002falces
fallen93813372fallen
faller94621232faller
fallers103917992fallers
falls85727652fa_lls
false84818122fa_lse
fames105735922fa_mes
fanes84639892fa_nes
farads104713272farads
farce104925322farce_
farced125216532farced
farcer115016082farcer
farcers124713442farcers
farcies125317882farcies
farded114518952farded
fardel104712592fardel
fardels11389892fardels
fards96629842far_ds
fare76354462far_e_
fared95842342far_ed
farer86733142far_er
farers95924052farers
farfel124310432farfel
farfels13348212farfels
farl76338552farl__
farmed125117652farmed
farmer115017372farmer
farmers124315262farmers
farms106324952far_ms
farness102912202farness
faros85532022far_os
farted105121782farted
fartlek1434492fartlek
fartleks1533962fartleks
farts88336842far_ts
fasces114914542fasces
fashes124524022fashes
fates85139232fa_tes
fatless103212202fatless
fauces114916152fauces
faulds10438962faulds
faults94513552faults
fauves125610422fauves
faves115331422fa_ves
faxes155726652fa_xes
fazes175527212fa_zes
fearless1137872fearless
feres86038182fer_es
ferlies103216692ferlies
ferules103112722ferules
files85441272f_iles
filles94224522filles
fires85740752fir_es
flares94521702flar_es
folles93820472folles
forces114422132forces
fores85847102for_es
forges105024262forges
formes114623712formes
fortes95327182fortes
frames115119862frames
frees86131392f_rees
fries85535602f_ries
froes86126692f_roes
fugles104715782fugles
furies95126372furies
furled104717052furled
furler93616402furler
furlers104214222furlers
furless103210142furless
furls85322052furl_s
furzes186613692furzes
gables94222332gables
gales65442482ga_les
garbles104016922garbles
gargles94214892gargles
hales85449842ha_les
haoles94919802haoles
hares86255542har_es
harls85634502harl_s
jarls126120962jarl_s
kales95730982ka_les
kayles134712002kayles
ladles74619542ladles
larees65323112larees
lares54852632lar_es
larges74824232larges
macles107023222macles
mailes84329112mailes
males75049792ma_les
maples104819422maples
marbles114516652marbles
mares76457632mar_es
marges94525712marges
marled95523162marled
marls75535162marl_s
marses84827112marses
merles85322762merles
nares55544152nar_es
oarless73913372oarless
orles55326212_orles
padles95221122padles
pales75753802pa_les
pares77164482par_es
parges94529542parges
paries84742512paries
parle75836162parle_
parled94626282parled
parley116718352parley
parleys125212372parleys
paroles95025882paroles
parses85534702parses
rales54947492ra_les
rares55247442rar_es
sables85026692sables
sales56055592sa_les
sarees65329942sarees
sarges75128592sarges
tables84524892tables
tales55451372ta_les
tares57456562tar_es
targes74524592targes
tarres64723042tarres
vales85434262va_les
varies94330872varies
varlet9423502varlet
varlets10411572varlets
varves124414782varves
wales86142832wa_les
warbles123215562warbles
wares88250582war_es
warless104015102warless
warsles103413642warsles

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 Filter178691825510.1101624463.6
2DLD Change Limit825511922.45333653.1
3Display Results1921920.0633047.6
 (SQL Overall)1786911922.62668046.8
 
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.