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
hinge9532344(None) 
binge85125511binge
dinge75627301dinge
henge94819821henge
hinged114618911hinged
hinger104723311hinger
hinges105121021hinges
singe65731131singe
tinge64626611tinge
whinge134311531whinge
ahing98928342ahing_
bilge87618912bilge
bine66650852bin_e
binged105920822binged
binger94923442binger
binges93923122binges
bingo86020092bingo
change124116752change
chine105231722chin_e
cine66242942cin_e
conge85227592conge
cringe93515482cringe
dine55555332din_e
ding66940952ding_
dinged95221782dinged
dinger85323662dinger
dinges83825422dinges
dingey114914042dingey
dingle84317072dingle
dingo74720792dingo
dings76331402dings
dingy105721262dingy
dirge75117072dirge
fidge104516052fidge
fine75147952fin_e
finger104920322finger
fringe104013952fringe
ginger84920022ginger
hance105424152hance
hang85535542hang_
hanged114222392hanged
hanger104023252hanger
hangs95726722hangs
hanse85722792hanse
hedge105317332hedge
heinie92512662heinie
hence104920042hence
henges104516452henges
hide85134622hi_de
hie67652702hi__e
higgle113811742higgle
high116619912hi_gh
hike116830392hi_ke
hin67559562hin__
hind85529752hin_d
hinder104120062hinder
hinds96721472hinds
hingers113420192hingers
hinky155618752hinky
hinny115616672hinny
hins76447992hin_s
hint77455742hin_t
hinted104318322hinted
hinter94021302hinter
hints87330622hints
hire75538962hi_re
hiree85427802hiree
hive106029672hi_ve
hone77549322hon_e
hong85833952hong_
hongi96715852hongi
hongs95126202hongs
huge86321652h_uge
hung86126352hung_
hunger104015202hunger
hying126514742hying_
ingle64120432_ingle
jingle143815222jingle
jingo134615212jingo
kine85643422kin_e
king95933652king_
kinged124215282kinged
kings105825562kings
liege65314432liege
linage7713402linage
line46965572lin_e
ling57447962ling_
linga66820812linga
linger75225992linger
lingo66022102lingo
lings67135772lings
lingy96925132lingy
longe66626462longe
lunge65323802lunge
mange84930182mange
midge95016542midge
minae75627722minae
mince95325232mince
mine67256152min_e
mingle93518782mingle
mingy115520182mingy
minke115421762minke
nine45842172nin_e
ohing96018802ohing_
pine67755712pin_e
ping75943592ping_
pinged104321382pinged
pinger94324082pinger
pingo87122712pingo
pings85830882pings
range64728412range
rehinge1148502rehinge
ridge75018662ridge
ring56541152ring_
ringed84623842ringed
ringer74526052ringer
rings65029172rings
rinse54820972rinse
shine85533092shin_e
shingle117711272shingle
siege66718442siege
since75024172since
sine46560622sin_e
sing57544172sing_
singed85422292singed
singer74227302singer
singes74326852singes
single74520602single
sings65532702sings
swinge105614382swinge
tenge65720432tenge
thine85026852thin_e
thing96622962thing_
things104914282things
tine45855132tin_e
ting56139892ting_
tinged84220792tinged
tinges74722322tinges
tingle74319052tingle
tings65329192tings
twinge104210392twinge
unhinge11237282unhinge
venge95117982venge
vine75643682vin_e
whine116022812whin_e
whinged15409142whinged
whinger1410810902whinger
whinges143610622whinges
wince105220882wince
wine74953422win_e
wing86339222wing_
winged114620832winged
winger104125432winger
wings95727242wings
wingy126521032wingy
winze175014852winze
yince105214252yince
zine137036152zin_e
zing145728612zing_
zinged174414622zinged
zinger163816692zinger
zings154620892zings
zingy186516132zingy

Search took 4 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.1231452772.4
2DLD Change Limit538001632.84618903.7
3Display Results1631630.0931752.7
 (SQL Overall)1786911633.06258357.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.