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

178 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
farle8692924(None) 
carle74535701carle
fable105824751fable
farce104925321farce
fare76354461far_e
farl76338551farl_
farles96025781farles
farls85731111farls
parle75836161parle
able66340532_able
ale36572342_a_le
are37874572_ar_e
argle65421562_argle
arles56735742_arles
arse46539272_arse
axle116424602_axle
bale66353842ba_le
barbe95328282barbe
barde85330772barde
bare65460522bar_e
barge85631022barge
barley115116762barley
barre75929542barre
barye105021492barye
birle75023632birle
cable95329912cable
care66968372car_e
carl65144782carl_
carles85435082carles
carls77037422carls
carse74934332carse
carte75940422carte
carve106227752carve
dale55643982da_le
dare55848862dar_e
darkle113813942darkle
dartle73714832dartle
eagle64219482eagle
earl45838142earl_
earls56127512earls
early85324122early
fabled124216382fabled
fabler116115812fabler
fables114921672fables
face96140122fa_ce
facile112514882facile
fade85736342fa_de
fadge104816992fadge
faerie93514682faerie
fail74840242fail_
failed105421602failed
faille93414742faille
fails85631482fails
fairly125610012fairly
fake115534942fa_ke
fall75535312fa_ll
fallen93813372fallen
faller94621232faller
falls85727652falls
false84818122false
falx147120782fa_lx
fame95639392fa_me
fane75343562fa_ne
far67762602far__
farad95720672farad
farced125216532farced
farcer115016082farcer
farces115223322farces
farci105919312farci
farcie114816472farcie
farcy135217092farcy
fard85639062far_d
farded114518952farded
fardel104712592fardel
fards96629842fards
fared95842342fared
farer86733142farer
fares85852872fares
farfel124310432farfel
farm95934532far_m
farmed125117652farmed
farmer115017372farmer
farms106324952farms
faro76136922far_o
faros85532022faros
fart76860562far_t
farted105121782farted
fartlek1434492fartlek
farts88336842farts
fate75444282fa_te
fatly115716802fatly
fauld95214492fauld
fault85428312fault
fauve114712072fauve
fave105532962fa_ve
faze165630042fa_ze
fere76342232fer_e
ferlie92814052ferlie
ferly115517352ferly
ferule93413202ferule
file75446642f_ile
fille84327402fille
fire76245592fir_e
flare84823632flar_e
force105324272force
fore78351472for_e
forge95126942forge
forme105225992forme
forte86131462forte
frae75330472f_rae
frame105821802frame
free75940182f_ree
froe75329992f_roe
fugle94915542fugle
furl77030882furl_
furled104717052furled
furler93616402furler
furls85322052furls
furze176815812furze
gable85325522gable
gale56347322ga_le
garble94118452garble
gargle84215462gargle
hale76052832ha_le
haole84820082haole
hare76255732har_e
harl75740002harl_
harls85634502harls
jarl115828132jarl_
jarls126120962jarls
kale86533752ka_le
ladle66320442ladle
laree56036292laree
large65325462large
macle96127002macle
maile75232212maile
male66052292ma_le
maple95521142maple
marble104219102marble
mare64759322mar_e
marge85328332marge
marl66341612marl_
marled95523162marled
marls75535162marls
marly106925612marly
marse76231152marse
merle75824372merle
orle45630462_orle
padle84522342padle
pale66055012pa_le
parae76335702parae
pare66760842par_e
parge85831852parge
parled94626272parled
parles86334392parles
parley116718352parley
parole84425252parole
parse75236992parse
parve109824852parve
rale45050562ra_le
rare45348432rar_e
sable74732162sable
sale44959702sa_le
saree55044662saree
sarge65531132sarge
table75429602table
tale46154162ta_le
tare45957622tar_e
targe65227092targe
tarre55825632tarre
vale74937342va_le
varlet9423502varlet
varve115716852varve
wale74546432wa_le
warble113516602warble
ware76254722war_e
warsle93112922warsle
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.1231452772.4
2DLD Change Limit538001781.84629144.1
3Display Results1781780.0463869.6
 (SQL Overall)1786911782.01588680.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.