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

228 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
gien5633002(None) 
gaen57329601gaen
gen45950511g_en
gie47149541gie_
gied64631981gied
gies55641421gies
gin46055751gi_n
girn56026861girn
given95915281given
glen56027201glen
lien45339801lien
mien65028351mien
agin56132712agi_n
ain37579092ai_n
airn46433832airn
alien56425582alien
amen66733152amen
been65335782been
ben56554922_ben
bier65531822bier
bin56658632bi_n
bine66650852bine
bren65629562bren
cine66242942cine
cion613330912cion
den47554342_den
die46759652die_
died66137852died
diel59034602diel
diene65720132diene
dies55653522dies
diet57357532diet
din46459462di_n
dine55555332dine
dizen155214932dizen
en28052392__en
even75222272even
eyen76223662eyen
fen66851352_fen
fie67152442fie_
fief107331352fief
fiend95312982fiend
fin66458032fi_n
fine75147952fine
firn76927502firn
gae46457702gae_
gaed66031512gaed
gaes56348032gaes
gain56042162gain
gan48060122g_an
gane55145292gane
gaun56427712gaun
ged57044532g_ed
gee45359202g_ee
geed65435502geed
geek95327022geek
gees55647882gees
geez146424862geez
gel45642432g_el
gem66840222g_em
gene56237222g_ene
gens55740072g_ens
gent56954392g_ent
genu55929072g_enu
get47467462g_et
gey75738302g_ey
ghee85726112ghee
giant65430592giant
gib66443522gi_b
gibe75927772gibe
gibed96215962gibed
giber85417702giber
gibes84422522gibes
gibs75529262gibs
gid57047262gi_d
gids65933732gids
gieing83614852gieing
gift86735792gift
gig56040752gi_g
giga66720942giga
gigs66631182gigs
gild65526512gild
gill56336182gill
gilt56348542gilt
gimel8313352gimel
gimp96124042gimp
gink97129522gink
ginny95314572ginny
gins55543952gins
gip67645362gi_p
gipon84212412gipon
gips75632922gips
gird65424992gird
girl56226552girl
girns64516802girns
giro55828632giro
giron66118992giron
girt56646422girt
gist56046762gist
git46266052gi_t
gite55438612gite
gites65630182gites
gits55744592gits
give85829352give
givens10379732givens
giver94921202giver
gives95324872gives
glean65818202glean
gled65631142gled
glee55239062glee
gleg66219802gleg
glens66519852glens
gley85724652gley
goer56827102goer
goes55644092goes
gone55639042gone
goon57236172goon
gown85724072gown
gran56335012gran
gree56641562gree
green65522142green
grew85620262grew
grey85624042grey
grief95319772grief
grin55733722grin
guan55325582guan
gun47240802g_un
gwine95513662gwine
haen76229452haen
hen67555272_hen
hie67652702hie_
hied85434042hied
hies74842832hies
hin67559562hi_n
hisn79620932hisn
in28150862_i_n
inn36727432_inn
ion36051022_ion
jin106443932ji_n
jinn115420242jinn
keen84830402keen
ken76343982_ken
kief117128392kief
kier86526802kier
kiln85620972kiln
kin76353962ki_n
kine85643422kine
kirn87123432kirn
lie38264522lie_
lied55838092lied
lief76036982lief
liens56525502liens
lier45942462lier
lies46454192lies
lieu46534362lieu
liken911818842liken
limen75426032limen
limn66527692limn
lin37967372li_n
line46965572line
linen55728722linen
linn46034592linn
lion46334442lion
liven85021732liven
men59252842_men
miens76118302miens
mine67256152mine
mizen164815272mizen
nine45842172nine
omen66828182omen
open66427002open
oven76624142oven
oxen116218592oxen
peen65938082peen
pein65834942pein
pen56558842_pen
pian66136092pian
pie55457402pie_
pied75035362pied
pier66035292pier
pies66949602pies
pin57066722pi_n
pine67755712pine
pion67235292pion
pirn67128372pirn
rein46040892rein
riel46432382riel
rin36663182ri_n
ripen75619262ripen
risen54621882risen
riven85121622riven
seen46943122seen
sen36058522_sen
sign55523052sign
sin36265892si_n
sine46560622sine
siren54525822siren
teen45938202teen
ten35856112_ten
then78429692then
tie36557532tie_
tied55535212tied
tier44936142tier
ties45248312ties
tin36362172ti_n
tine45855132tine
vein75625752vein
vie65447632vie_
vied86328632vied
vier75428152vier
vies75238622vies
view105917672view
vimen104114752vimen
vine75643682vine
vixen153010022vixen
ween75835462ween
wen66249602_wen
when105723042when
widen94717972widen
win66456292wi_n
wine74953422wine
wizen175813862wizen
wren78221682wren
yen66847382_yen
yin67648732yi_n
zein135620602zein
zin125643772zi_n
zine137036152zine

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 Filter178691298720.0762351197.4
2DLD Change Limit298722281.00029872.0
3Display Results2282280.0802850.0
 (SQL Overall)1786912281.156154577.0
 
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.