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

248 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
iring6602542(None) 
airing74927501airing
bring85528501bring
firing104021721firing
hiring104421601hiring
icing86017751icing
irking114611751irking
miring93723801miring
ring56541151_ring
siring75128311siring
tiring74023091tiring
wiring104521021wiring
wring95920711wring
acing87429152acing
aging77026352aging
ahing98928352ahing
aiding84423612aiding
ailing74331012ailing
aiming94320842aiming
airings83913842airings
airting83616302airting
aping87327232aping
arcing95819642arcing
arming94719802arming
awing96827322awing
axing138521372axing
baring95135852baring
being84920502being
biding104720792biding
biking135018172biking
birding114014922birding
birling104317052birling
birring103713062birring
biting95321822biting
boing84725552boing
boring94724872boring
brig76528032bri_g
brin67038192brin_
brine75132272brine
brings94618432brings
brink116122002brink
brins75533972brins
briny104719662briny
brung84613912brung
caring95137992caring
cering94522532cering
citing94220182citing
cling86424672cling
coring94433962coring
cringe93515482cringe
crying123612282crying
cuing85420192cuing
curing94824782curing
daring84928682daring
dicing105718762dicing
dieing84018652dieing
diking124320242diking
ding66940952_ding
dining84525132dining
dirking133812602dirking
dirling93316072dirling
diving113717952diving
doing74923582doing
drink106816382drink
drying113411602drying
during84419402during
dying105316032dying
earing75235482earing
eking106614982eking
eringo739552eringo
erring73816482erring
exing136016812exing
eying96117922eying
fairing113614012fairing
faring105231282faring
fifing134212342fifing
filing103823762filing
fining104223212fining
firings114112332firings
firming132811222firming
fixing174813782fixing
fling97023512fling
frig85424502fri_g
fringe104013952fringe
fringy13309262fringy
frying134511402frying
gibing103712352gibing
gieing83614852gieing
girding103611882girding
girning93210692girning
girting93113332girting
giving114313882giving
going75218492going
goring84119572goring
grig65424772gri_g
grin55733722grin_
grind75917562grind
gringa838552gringa
gringo838642gringo
grins65427222grins
gyring113910362gyring
haring104233002haring
heiring113312902heiring
hiding114319332hiding
hieing104216622hieing
hiking143617102hiking
hiving134115522hiving
hying126514742hying
icings9428452icings
idling8912882idling
igging93212072igging
imine75821062imine
imino74315232imino
imping114315352imping
inking115119052inking
inning73617632inning
inuring81213012inuring
irid55927172iri_d
irids66417772irids
iris45732552iri_s
irising83614422irising
iron46728462iron_
irone55126362irone
ironing82414012ironing
irons55324132irons
irony85015902irony
isling71213882isling
jibing16379622jibing
jiving173711602jiving
king95933662_king
kirning12319332kirning
kiting114117092kiting
lairing83715342lairing
liking114319582liking
liming94021242liming
ling57447962_ling
lining74526802lining
living104318322living
luring73820752luring
lying95717452lying
miking134218462miking
miming114317262miming
mining94225452mining
mirin75023152mirin_
mirins83918902mirins
mitring103514142mitring
mixing164713942mixing
muring95120372muring
niding83217982niding
nixing143311492nixing
oaring74225302oaring
ohing96018812ohing
oiling74925312oiling
oping86322412oping
orang65119942orang
orbing93312362orbing
owing96222722owing
pairing103716732pairing
paring94236492paring
pieing93917652pieing
piing85218832piing
piking133719642piking
piling95025592piling
ping75943592_ping
pining93726532pining
piping114017452piping
poring94227272poring
prang84820322prang
prig75924872pri_g
prink114719672prink
print74837462print
prong85218112prong
prying124114802prying
quiring17159992quiring
rang56939172_rang
raring74332872raring
ricing94822762ricing
riding84325962riding
rig46748122_ri_g
riling74227972riling
riming93322222riming
rin36663182_rin_
rind56535602_rind
rings65029172_rings
rink87736992_rink
rins46153192_rins
riping93821612riping
rising74025882rising
riving104521422riving
ruing67221052ruing
rung56429982_rung
sering74731812sering
siding83822132siding
sing57544172_sing
siping94220632siping
siting74126622siting
sizing163616442sizing
sling66028802sling
soring74731882soring
spiring103918182spiring
spring94526012spring
sting65330242sting
string75327562string
suing65026362suing
swing96124842swing
taring73932282taring
thing96622982thing
tiding83520092tiding
tieing73518762tieing
tiering8315252tiering
tiling73426552tiling
timing93619302timing
ting56139912_ting
tining74927542tining
tirling83315732tirling
trig55528162tri_g
trine54734602trine
truing73913932truing
trying104214072trying
tying96019842tying
tyring104613022tyring
urging83413122urging
urine55026602urine
urping93914052urping
using66317962using
vicing124014242vicing
viking143414612viking
vining104619462vining
vising103915872vising
vying125111812vying
wairing113414312wairing
waring105029442waring
wifing133513392wifing
wiling103024292wiling
wing86339222_wing
wining103625052wining
wiping123916712wiping
wirings113910112wirings
wising103318222wising
witing103522822witing
wiving133316602wiving
wrang94716112wrang
wrings104012972wrings
wrong94712322wrong
wrung9549802wrung
wrying13379622wrying
yirring11307762yirring
zing145728612_zing

Search took 3 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 Limit538002481.64032804.9
3Display Results2482480.0633936.5
 (SQL Overall)1786912481.99989390.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.