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

163 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
hinge9532345(None) 
binge85125511binge
dinge75627301dinge
henge94819831henge
hinged114618921hinged
hinger104723331hinger
hinges105121031hinges
singe65731131singe
tinge64626631tinge
whinge134311541whinge
ahing98928352ahing_
bilge87618912bilge
bine66650872bin_e
binged105920822binged
binger94923452binger
binges93923122binges
bingo86020092bingo
change124116752change
chine105231722chin_e
cine66242952cin_e
conge85227592conge
cringe93515482cringe
dine55555342din_e
ding66940962ding_
dinged95221782dinged
dinger85323672dinger
dinges83825422dinges
dingey114914052dingey
dingle84317072dingle
dingo74720792dingo
dings76331402dings
dingy105721262dingy
dirge75117072dirge
fidge104516072fidge
fine75147962fin_e
finger104920332finger
fringe104013952fringe
ginger84920032ginger
hance105424152hance
hang85535562hang_
hanged114222402hanged
hanger104023262hanger
hangs95726732hangs
hanse85722792hanse
hedge105317352hedge
heinie92512662heinie
hence104920052hence
henges104516462henges
hide85134652hi_de
hie67652712hi__e
higgle113811742higgle
high116619932hi_gh
hike116830402hi_ke
hin67559572hin__
hind85529762hin_d
hinder104120062hinder
hinds96721482hinds
hingers113420212hingers
hinky155618752hinky
hinny115616672hinny
hins76448002hin_s
hint77455752hin_t
hinted104318322hinted
hinter94021302hinter
hints87330622hints
hire75538972hi_re
hiree85427802hiree
hive106029682hi_ve
hone77549322hon_e
hong85833952hong_
hongi96715872hongi
hongs95126202hongs
huge86321652h_uge
hung86126352hung_
hunger104015202hunger
hying126514742hying_
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
ohing96018812ohing_
pine67755722pin_e
ping75943602ping_
pinged104321382pinged
pinger94324092pinger
pingo87122712pingo
pings85830882pings
range64728422range
rehinge1148502rehinge
ridge75018682ridge
ring56541162ring_
ringed84623842ringed
ringer74526062ringer
rings65029172rings
rinse54820972rinse
shine85533092shin_e
shingle117711282shingle
siege66718442siege
since75024172since
sine46560632sin_e
sing57544182sing_
singed85422292singed
singer74227312singer
singes74326852singes
single74520602single
sings65532702sings
swinge105614382swinge
tenge65720452tenge
thine85026862thin_e
thing96622982thing_
things104914302things
tine45855142tin_e
ting56139922ting_
tinged84220812tinged
tinges74722342tinges
tingle74319072tingle
tings65329212tings
twinge104210402twinge
unhinge11237282unhinge
venge95117992venge
vine75643692vin_e
whine116022812whin_e
whinged15409152whinged
whinger1410810912whinger
whinges143610632whinges
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 Limit538001631.47036598.6
3Display Results1631630.0463543.5
 (SQL Overall)1786911631.81298615.3
 
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.