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

233 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
farside113860(None) 
farsides1237991farsides
arsine64021042_arsine
aside65122092_a_side
carbide126112492carbide
dayside1236172dayside
falsie93513852falsi_e
farcie114816472farci_e
fireside1247012fireside
foreside12310302foreside
nearside944922nearside
wayside1435182wayside
abide86223723_a_bide
afraid1049723afraid_
aide56045013_a__ide
alsike1047913_alsike
amide86128493_a_mide
apsides103911303_apsides
arcade91013643_arcade
arcsine94512393_arcsine
arid57642723_ar_id_
arider74717743_ar_ider
arise56436433_ar_ise
aroid65428343_aroid_
aroids75118223_aroids
arrive91311793_arrive
arse46539273_ars__e
arsenide9116333_arsenide
arsines73518833_arsines
arsino64113513_arsino
arsis55722423_arsi_s
asides75118873_a_sides
assize1538633_assize
azide155617173_a_zide
backside17108143backside
bankside15115653bankside
barbie105018353barbi_e
barde85330773bar__de
barite84224813bar_ite
barmie103816403barmi_e
bedside1156843bedside
beside95114613_beside
boride9415903bor_ide
bride86425543_br_ide
capsid11312423capsid_
capsids1239333capsids
capsize2037623capsize
carbides133111693carbides
carbine112918643carbine
cardiae10713713cardiae
caribe103416753car_ibe
caried94528693car_ied
carline93923623carline
carmine112918483carmine
carnie84421093carni_e
carried103717153carried
carse74934333cars__e
carsick1536343carsick
cassine93817283cassine
curbside1344673curbside
cursive1237833cursive
daisied93410013daisied
darkie113714013darki_e
dassie74615573dassi_e
daysides1335963daysides
depside1138413depside
deride84420033der_ide
facade1238803fa_cade
faciae112913413fa_ciae
facile112514883fa_cile
fade85736353fa___de
fadlike15318483fadlike
faerie93514683faeri_e
false84818123fals__e
falsies103515013falsies
falsify1643613falsify
falsity1335913falsity
famine114318193fa_mine
fancied133310603fancied
fanlike142610503fanlike
fanwise1336633fanwise
fanzine1937123fanzine
farad95720683far_ad_
faradic1337693faradic
faradise12219393faradise
faradize21237823faradize
farads104713273far_ads
farce104925323far__ce
farced125216533farced_
farci105919313farci__
farcies125317883farcies
farcing133514003farcing
fard85639063far__d_
farded114518953far__ded
fardel104712593far__del
farding123716743farding
fards96629843far__ds
fare76354463far___e
fared95842343far_ed_
farina94618233far_ina
faring105231283far_ing
farle86929243far__le
farmed125117663farmed_
farming133515083farming
farmwife1942173farmwife
farrier103514893farrier
farted105121783farted_
farting114120753farting
fasciae1247523fasciae
fascine12510583fascine
fashed136720253fa_shed
fasted105320953fa_sted
fatlike142911193fatlike
fearsome1345113fearsome
felsite1039083felsite
feriae95618603fer_iae
ferine96422583fer_ine
ferlie92814053ferli_e
ferried113411533ferried
ferrite103312753ferrite
fertile10311733fertile
fervid1337513fervid_
firesides1346613firesides
fissile10269653fissile
forbade13259103forbade
forbid123312433forbid_
forbids13268263forbids
forbode13257963forbode
fordid113512053fordid_
foresides1339713foresides
forgive1436193forgive
forsake1436533forsake
fragile1147843fragile
fraise94214913f_raise
fridge11379253f_r_idge
fried95322913f_r_ied
frise85322453f_r_ise
frisee94217993f_risee
furtive1337173furtive
fusile94313493f_usile
garpike1435093garpike
gawsie1038463gawsi_e
gride75223593_gr_ide
hagride1237553hagride
halide103417993ha_lide
harmine122816193harmine
harried113815543harried
hayride1437323hayride
inside7613453_inside
jarosite1548383jarosite
jassid1467223jassid_
jassids1586143jassids
lakeside1344673lakeside
landside10147443landside
larine63927043lar_ine
lassie64917743lassi_e
marine84230413mar_ine
marline93320973marline
marlite92917083marlite
marmite112413993marmite
married104715303married
marse76231153mars__e
massive12289773massive
nardine82712573nardine
nargile847653nargile
narine63422553nar_ine
nearsides1044523nearsides
oarlike113411193oarlike
offside1453693offside
onside7511803_onside
oreide7311673_oreide
oroide7311703_oroide
outside82414193outside
overside122013933overside
palsied102911303palsied
parade94720643par_ade
parasite10314843parasite
pardie96021443pardi_e
pardine103616733pardine
parkade1437583parkade
parridge1254333parridge
parried103615723parried
parse75236993pars__e
parsed96323893parsed_
parsing103819553parsing
parslied1137823parslied
partied103516553partied
partite9317133partite
parvise124211693parvise
passade1039233passade
passive12239593passive
portside1138163portside
preside10715613preside
pride84724743_pr_ide
quayside2143473quayside
raphide13138073raphide
rawhide14134973rawhide
reside74224933_reside
ride55945143__r_ide
roadside1044893roadside
sardine83317393sardine
sarode75317513sar_ode
seaside839693seaside
side55444503___side
stride75420963str_ide
subside10410453subside
surfside1244853surfside
tardive1136893tardive
tarried83914133tarried
tarsi55222173tarsi__
tarsia65514273tarsi_a
tarsias74013373tarsias
tarsier74119253tarsier
tassie66017023tassi_e
topside1037743topside
torsade837593torsade
upside9289803_upside
uranide82212093uranide
ureide7310363_ureide
ursid6311483_ursid_
ursids737823_ursids
ursine64114123_ursine
varied104817863var_ied
varsity1356673varsity
versine102515173versine
warlike142410473warlike
warsle93112923wars_le
warsled112910443warsled
warstle10328013warstle
wartime1237743wartime
waterside1345813waterside
waysides1544453waysides
weakside1642843weakside

Search took 8 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 Filter1786911340270.406440125.6
2DLD Change Limit1340272337.15618729.3
3Display Results2332330.0763065.8
 (SQL Overall)1786912337.63823395.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.