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

187 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
binge8512551(None) 
bilge87618911bilge
bine66650861bin_e
binged105920821binged
binger94923451binger
binges93923121binges
bingo86020091bingo
dinge75627301dinge
hinge95323451hinge
singe65731131singe
tinge64626621tinge
badge94819692badge
bane65250432ban_e
bang74837002bang_
banged104923722banged
banger94423632banger
bangle94018952bangle
bangs85627772bangs
barge85631022barge
beige81515382beige
beigne9148612beigne
being84920502being_
beings94613032beings
bene66439492ben_e
benne76521122benne
bible95119422bible
bice86235562bi_ce
bide76041502bi_de
big67345722bi_g_
bigger104315062bigger
biggie103810932biggie
biggy124413132biggy
bigs76235022bi_gs
bike106532602bi_ke
bikie113915882bikie
bile66147182bi_le
bilged105513182bilged
bilges94915632bilges
bilgy114713712bilgy
bin56658642bin__
binal75323822binal
binate8419772binate
bind76234512bin_d
binder94422872binder
bindi85617012bindi
bindle94516262bindle
binds86627472binds
biner75930692biner
bines76946792bines
bingers104519992bingers
bingoes104013982bingoes
bingos95514792bingos
binit76431582binit
binned94414542binned
bins66548252bin_s
bint67355042bin_t
bints76130182bints
biog76122322biog_
biogen9310252biogen
biogs85016112biogs
biome94916992biome
birle75023632birle
birse74517402birse
bise66437102bi_se
bite66547002bi_te
bize155926292bi_ze
blunge94311482blunge
boing84725552boing_
boings96416872boings
bone65949322bon_e
bong75633412bong_
bonged105719602bonged
bongo85720942bongo
bongs87828422bongs
bonne75124712bonne
bonze165119352bonze
bridge103711882bridge
brine75132272brin_e
bring85528502bring_
bringer104213352bringer
brings94618432brings
budge94619882budge
bulge86419872bulge
bung75730632bung_
bunged105218792bunged
bungee96319772bungee
bungle97116112bungle
bungs85323862bungs
cine66242942cin_e
conge85227592conge
cringe93515482cringe
dine55555332din_e
ding66940952ding_
dinged95221782dinged
dinger85323672dinger
dinges83825422dinges
dingey114914052dingey
dingle84317072dingle
dingo74720792dingo
dings76331402dings
dingy105721262dingy
dirge75117072dirge
fidge104516062fidge
fine75147952fin_e
finger104920332finger
fringe104013952fringe
ginger84920032ginger
henge94819832henge
hinged114618922hinged
hinger104723332hinger
hinges105121032hinges
ingle64120432_ingle
jingle143815222jingle
jingo134615212jingo
kine85643432kin_e
king95933662king_
kinged124215292kinged
kings105825562kings
liege65314432liege
linage7713402linage
line46965572lin_e
ling57447962ling_
linga66820822linga
linger75226002linger
lingo66022112lingo
lings67135772lings
lingy96925142lingy
longe66626462longe
lunge65323802lunge
mange84930192mange
midge95016552midge
minae75627722minae
mince95325232mince
mine67256172min_e
mingle93518782mingle
mingy115520182mingy
minke115421762minke
nine45842172nin_e
pine67755712pin_e
ping75943592ping_
pinged104321382pinged
pinger94324092pinger
pingo87122712pingo
pings85830882pings
range64728412range
ridge75018672ridge
ring56541152ring_
ringed84623842ringed
ringer74526062ringer
rings65029172rings
rinse54820972rinse
siege66718442siege
since75024172since
sine46560622sin_e
sing57544172sing_
singed85422292singed
singer74227312singer
singes74326852singes
single74520602single
sings65532702sings
swinge105614382swinge
tenge65720442tenge
tine45855132tin_e
ting56139902ting_
tinged84220802tinged
tinges74722332tinges
tingle74319062tingle
tings65329202tings
twinge104210402twinge
venge95117992venge
vine75643682vin_e
whinge134311542whinge
wince105220882wince
wine74953422win_e
wing86339222wing_
winged114620832winged
winger104125442winger
wings95727242wings
wingy126521032wingy
winze175014852winze
yince105214252yince
zine137036152zin_e
zing145728612zing_
zinged174414622zinged
zinger163816702zinger
zings154620892zings
zingy186516132zingy

Search took 2 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.326548131.9
2DLD Change Limit538001871.47036598.6
3Display Results1871870.0464065.2
 (SQL Overall)1786911871.84297009.2
 
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.