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
bine66650871bin_e
binged105920821binged
binger94923451binger
binges93923121binges
bingo86020091bingo
dinge75627301dinge
hinge95323451hinge
singe65731131singe
tinge64626631tinge
badge94819692badge
bane65250432ban_e
bang74837012bang_
banged104923732banged
banger94423642banger
bangle94018962bangle
bangs85627782bangs
barge85631022barge
beige81515382beige
beigne9148612beigne
being84920502being_
beings94613032beings
bene66439492ben_e
benne76521122benne
bible95119422bible
bice86235572bi_ce
bide76041512bi_de
big67345732bi_g_
bigger104315062bigger
biggie103810932biggie
biggy124413132biggy
bigs76235032bi_gs
bike106532612bi_ke
bikie113915882bikie
bile66147192bi_le
bilged105513182bilged
bilges94915632bilges
bilgy114713712bilgy
bin56658652bin__
binal75323822binal
binate8419772binate
bind76234522bin_d
binder94422872binder
bindi85617022bindi
bindle94516262bindle
binds86627482binds
biner75930692biner
bines76946792bines
bingers104519992bingers
bingoes104013982bingoes
bingos95514792bingos
binit76431582binit
binned94414542binned
bins66548262bin_s
bint67355052bin_t
bints76130182bints
biog76122332biog_
biogen9310252biogen
biogs85016112biogs
biome94916992biome
birle75023632birle
birse74517402birse
bise66437112bi_se
bite66547012bi_te
bize155926302bi_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
cine66242952cin_e
conge85227592conge
cringe93515482cringe
dine55555342din_e
ding66940962ding_
dinged95221782dinged
dinger85323672dinger
dinges83825422dinges
dingey114914052dingey
dingle84317072dingle
dingo74720792dingo
dings76331402dings
dingy105721262dingy
dirge75117072dirge
fidge104516072fidge
fine75147962fin_e
finger104920332finger
fringe104013952fringe
ginger84920032ginger
henge94819832henge
hinged114618922hinged
hinger104723332hinger
hinges105121032hinges
ingle64120432_ingle
jingle143815222jingle
jingo134615212jingo
kine85643442kin_e
king95933672king_
kinged124215292kinged
kings105825572kings
liege65314432liege
linage7713402linage
line46965582lin_e
ling57447972ling_
linga66820822linga
linger75226002linger
lingo66022112lingo
lings67135772lings
lingy96925142lingy
longe66626462longe
lunge65323802lunge
mange84930202mange
midge95016562midge
minae75627722minae
mince95325232mince
mine67256182min_e
mingle93518782mingle
mingy115520182mingy
minke115421762minke
nine45842182nin_e
pine67755722pin_e
ping75943602ping_
pinged104321382pinged
pinger94324092pinger
pingo87122712pingo
pings85830882pings
range64728422range
ridge75018682ridge
ring56541162ring_
ringed84623842ringed
ringer74526062ringer
rings65029172rings
rinse54820972rinse
siege66718442siege
since75024172since
sine46560632sin_e
sing57544182sing_
singed85422292singed
singer74227312singer
singes74326852singes
single74520602single
sings65532702sings
swinge105614382swinge
tenge65720452tenge
tine45855142tin_e
ting56139922ting_
tinged84220812tinged
tinges74722342tinges
tingle74319072tingle
tings65329212tings
twinge104210402twinge
venge95117992venge
vine75643692vin_e
whinge134311542whinge
wince105220882wince
wine74953432win_e
wing86339232wing_
winged114620832winged
winger104125442winger
wings95727242wings
wingy126521032wingy
winze175014852winze
yince105214252yince
zine137036162zin_e
zing145728622zing_
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.296603685.8
2DLD Change Limit538001871.61033416.1
3Display Results1871870.0464065.2
 (SQL Overall)1786911871.95291542.5
 
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.