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

183 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
dinge7562730(None) 
binge85125511binge
dine55555331din_e
ding66940951ding_
dinged95221781dinged
dinger85323671dinger
dinges83825421dinges
dingey114914051dingey
dingle84317071dingle
dingo74720791dingo
dings76331401dings
dingy105721261dingy
dirge75117071dirge
hinge95323451hinge
singe65731131singe
tinge64626621tinge
bilge87618912bilge
bine66650862bin_e
binged105920822binged
binger94923452binger
binges93923122binges
bingo86020092bingo
cine66242942cin_e
conge85227592conge
cringe93515482cringe
dance85223132dance
dang65131542dang_
danged94819482danged
danger83722822danger
dangle84119302dangle
dangs75623202dangs
dene56643412den_e
dengue838252dengue
dense65923502dense
dice75841892di_ce
didie74120562didie
die46759652di__e
diene65720132diene
dig57544472di_g_
digged104314652digged
digger94616082digger
digs66036052di_gs
dike95935762di_ke
dime76237642di_me
din46459462din__
dinar66319892dinar
dindle84417222dindle
dined76431992dined
diner65632902diner
dines66449152dines
dingers94321382dingers
dingeys12458402dingeys
dinghy14476962dinghy
dingier93513672dingier
dingies93618242dingies
dingles93818322dingles
dingoes94114832dingoes
dingus83611842dingus
dink97137802din_k
dinked124818352dinked
dinkey144812762dinkey
dinks105927952dinks
dinky135819372dinky
dinned84317612dinned
dinner74217162dinner
dino56036752din_o
dinos65428062dinos
dins56652042din_s
dint56759052din_t
dinted84419842dinted
dints67431312dints
diode74716112diode
dire56644142di_re
dirges84915102dirges
disme85716242disme
dite55547552di_te
dive85634772di_ve
dodge86618132dodge
doge66233802d_oge
doing74923582doing_
doings84913182doings
done55747912don_e
donee66931012donee
dong66031652dong_
donga76718422donga
dongle83612492dongle
dongs76525812dongs
donne65520462donne
dunce86319262dunce
dune56137582dun_e
dung66328432dung_
dunged95414692dunged
dungs75821972dungs
dungy104713642dungy
dwine95616142dwin_e
dying105316032dying_
dyings11478132dyings
dyne85320932dyn_e
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.313570897.8
2DLD Change Limit538001831.61033416.1
3Display Results1831830.0463978.3
 (SQL Overall)1786911831.96990752.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.