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

197 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
barge8563102(None) 
badge94819691badge
barbe95328281barbe
barde85330771barde
bare65460521bar_e
barege94713541barege
barged105822641barged
bargee94624451bargee
barges94528251barges
barre75929551barre
barye105021491barye
large65325461large
marge85328331marge
parge85831851parge
sarge65531131sarge
targe65227101targe
aargh96314082aargh
age47154332_a_ge
are37874572_ar_e
argle65421562_argle
argue64818442_argue
arse46539272_arse
babe86835822ba_be
bade75140882ba_de
badged114814792badged
badger105415082badger
badges103917372badges
bag67059222ba_g_
bagel85116792ba_gel
bagged114519902bagged
bagger104619202bagger
baggie102912192baggie
baggy125615682baggy
bags76645502ba_gs
baize164717392baize
bake105637512ba_ke
bale66353842ba_le
bane65250432ba_ne
bang74837012bang_
banged104923732banged
banger94423642banger
bangle94018962bangle
bangs85627782bangs
bar58070552bar__
barb85240062bar_b
barbed115121312barbed
barbel104317072barbel
barber104419322barber
barbes104526232barbes
barbet104427882barbet
barbie105018352barbie
barbs95928192barbs
barca91319432barca
bard75648862bar_d
barded105426422barded
bardes95026932bardes
bards87139642bards
bared85144482bared
bareges105212032bareges
barer74535802barer
bares75457132bares
barf95844412bar_f
barfed125416382barfed
barfs104826002barfs
bargees105415872bargees
baric96125692baric
barite84224812barite
bark106242152bar_k
barked135027312barked
barker124822862barker
barks115735812barks
barky145721612barky
barley115116762barley
barm86739602bar_m
barmen105418532barmen
barmie103816392barmie
barms96128462barms
barmy125218762barmy
barn66444642bar_n
barned95623582barned
barney115314452barney
barns76335142barns
barny105821732barny
baron78131242baron
barque17239552barque
barrage10710852barrage
barred95725802barred
barrel84517882barrel
barren85317622barren
barres84427552barres
barret84930492barret
bars66564092bar_s
barter85525382barter
baryes116218502baryes
baryte115312882baryte
base64847022ba_se
baste74829982baste
bate66552422ba_te
bathe105822882bathe
beige81515382beige
berg75425542berg_
bergs84718042bergs
berme96022942berme
bilge87618912bilge
binge85125512binge
birle75023632birle
birse74517402birse
blare75826232blar_e
borage93917012borage
bore66051332bor_e
borne77926792borne
brace95629272brace
brae65639112b_rae
brag75229722brag_
brags85625102brags
brake116025342brake
brave104925502brave
braze165423452braze
bree67241262b_ree
brie65837902b_rie
budge94619882budge
bulge86419872bulge
burg74930362burg_
burgee97120592burgee
burger94020792burger
burgh115216032burgh
burgle94815862burgle
burgs84924092burgs
burke115122762burke
burse75527252burse
byre95023852byr_e
cadge94018792cadge
cage75339062ca_ge
care66968372car_e
cargo85322072cargo
carle74535702carle
carse74934332carse
carte75940422carte
carve106227752carve
charge125114212charge
dare55848862dar_e
dirge75117072dirge
eagre64315322eagre
fadge104817002fadge
farce104925322farce
fare76354462far_e
farle86929242farle
forge95126942forge
gage65936102ga_ge
garage8314512garage
garget84327272garget
gargle84215462gargle
gauge76117902gauge
gorge76423892gorge
gurge75419782gurge
hare76255732har_e
laree56036302laree
larger74417512larger
larges74824232larges
largo65319782largo
mage75739132ma_ge
mange84930202mange
mare64759332mar_e
marges94525712marges
marse76231152marse
merge84523692merge
page76036102pa_ge
parae76335702parae
pare66760842par_e
parged104922042parged
parges94529542parges
parget94529392parget
pargo86723722pargo
parle75836162parle
parse75236992parse
parve109824852parve
purge85324602purge
rage55742352ra_ge
range64728422range
rare45348432rar_e
sage55044592sa_ge
saree55044662saree
sarges75128592sarges
sargo65424412sargo
serge64727472serge
sparge94216052sparge
surge65027692surge
tare45957622tar_e
targes74524602targes
target75028912target
tarre55825632tarre
urge54722422_urge
varve115716852varve
verge93419842verge
wage84834082wa_ge
ware76254722war_e
yare75636942yar_e

Search took 5 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.643277902.0
2DLD Change Limit538001973.51615301.5
3Display Results1971970.1061858.5
 (SQL Overall)1786911974.26541897.1
 
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.