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 “gingko” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

218 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
gingko1237603(None) 
gingkos13405341gingkos
ginkgo12334941ginkgo
jingko18505371jingko
bingo86020092bing_o
dingo74720792ding_o
gingal81010152gingal
ginger84920032ginger
gingkoes14404732gingkoes
gink97129532gin_k_
ginkgos13314182ginkgos
ginks104319562gin_ks
ginzo1539612gin_zo
gringo838642gring_o
jingo134615212jing_o
lingo66022112ling_o
pingo87122712ping_o
pinko115618252pin_ko
aging77026353aging__
agings86312673aging_s
anglo65215383_anglo
bangkok1341793bangkok
binge85125513bing_e
binged105920823binged
binger94923453binger
binges93923123binges
bingos95514793bingos
bongo85720943bong_o
bunko115514513bun_ko
congo85623133cong_o
dinero75612643dinero
ding66940963ding__
dinge75627303ding_e
dinged95221783dinged
dinger85323673dinger
dinges83825423dinges
dingey114914053dingey
dinghy14476963dinghy
dingle84317073dingle
dings76331403ding_s
dingus83611843dingus
dingy105721263ding_y
dink97137813din_k_
dinks105927953din_ks
dinky135819373din_ky
dino56036763din__o
eringo739553ering_o
finger104920333finger
finito9310303finito
fink117532133fin_k_
finks125424223fin_ks
fino76034703fin__o
fungo94413133fung_o
gang66031983gang__
ganged94619203ganged
ganger83721473ganger
gangly113911593gangly
gangs76222583gang_s
gangue81310583gangue
gecko124511113g_ecko
genro64914033gen_ro
gentoo7311313gentoo
gig56040763gi_g__
giga66720953gi_g_a
gigas75415583gi_gas
gigged104112293gigged
giggle94313513giggle
giggly12518703giggly
gighe10139733gi_ghe
giglot84013133gi_glot
gigolo836533gigolo
gigot74023073gi_got
gigs66631193gi_g_s
gigue71210673gi_gue
gin46055763gin___
gingall9117333gingall
gingals9109313gingals
gingeli9286153gingeli
gingely12378213gingely
gingers94118643gingers
gingery12368913gingery
gingham1484463gingham
gingili9306033gingili
gingiva1253293gingiva
ginkgoes14323743ginkgoes
ginned83813983ginned
ginner73915823ginner
ginny95314573gin_ny
gins55543963gin__s
giro55828643gi__ro
gismo848863gi_smo
gitano738043gitano
gizmo1756013gi_zmo
gogo69722833g_og_o
going75218493going__
goings84911523going_s
gong66827193gong__
gonged97115913gonged
gongs74921613gong_s
gonzo15310243gon_zo
grego7310523greg_o
gringa838553gring_a
gringas938043gringas
gringos936673gringos
gunk95423573gun_k_
gunks104517723gun_ks
gunky135514113gun_ky
hinge95323453hing_e
hinged114618923hinged
hinger104723333hinger
hinges105121033hinges
hinky155618753hin_ky
info75617353_in_fo
ingle64120433_ingle
ingot61221063_ingot
ink76433643_in_k_
inks86926503_in_ks
inky115321583_in_ky
inro45920793_in_ro
into45026153_in_to
intro54915853_intro
iroko939663_iroko
jingal1498593jingal
jingkoes20273723jingkoes
jingle143815223jingle
jingly174111933jingly
jink156227213jin_k_
jinks165019333jin_ks
king95933673king__
kingdom1543543kingdom
kinged124215293kinged
kingly143511303kingly
kings105825573king_s
kink76034413kin_k_
kinks84926093kin_ks
kinky115816393kin_ky
kino86233633kin__o
ling57447973ling__
linga66820823ling_a
lingam95112353lingam
lingas75116573lingas
lingcod1143683lingcod
linger75226003linger
lings67135773ling_s
lingua7509913lingua
lingy96925143ling_y
link86943453lin_k_
links96430193lin_ks
linky127622383lin_ky
lino46343383lin__o
mango85724333mang_o
mingle93518783mingle
mingy115520183ming_y
mink106636543min_k_
minke115421763min_ke
minks115829273min_ks
mongo810122413mong_o
mungo84916053mung_o
oink85429353oin_k_
oinks94819913oin_ks
olingo736933oling_o
pengo84317593peng_o
ping75943603ping__
pinged104321383pinged
pinger94324093pinger
pingos95317673pingos
pings85830883ping_s
pink107039393pin_k_
pinkos125313873pin_kos
pinks115729383pin_ks
pinky145823403pin_ky
pinto75625753pin_to
ring56541163ring__
ringed84623843ringed
ringer74526063ringer
rings65029173ring_s
rink87737003rin_k_
rinks94827103rin_ks
sicko115315393si_cko
sing57544183sing__
singe65731133sing_e
singed85422293singed
singer74227313singer
singes74326853singes
single74520603single
singly104015853singly
sings65532703sing_s
sink86640153sin_k_
sinks95529183sin_ks
stingo74212163sting_o
stinko10499393stin_ko
tango66921193tang_o
ting56139923ting__
tinge64626633ting_e
tinged84220813tinged
tinges74722343tinges
tingle74319073tingle
tingly103815983tingly
tings65329213ting_s
vino76128443vin__o
wing86339233wing__
wingbow1643773wingbow
winged114620833winged
winger104125443winger
wings95727243wing_s
wingy126521033wing_y
wink116435033win_k_
winks125325433win_ks
wino75933623win__o
zincky24404963zincky
zing145728623zing__
zingano1744203zingano
zingaro1745123zingaro
zinged174414623zinged
zinger163816703zinger
zings154620893zing_s
zingy186516133zing_y
zinky215314813zin_ky

Search took 6 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 Filter1786911127160.390458182.1
2DLD Change Limit1127162185.34621084.2
3Display Results2182180.0603633.3
 (SQL Overall)1786912185.79630830.1
 
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.