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

159 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
gingkos1340534(None) 
gingko12376031gingko_
gingkoes14404731gingkoes
ginkgos13314181ginkgos
bingos95514792bing_os
gingals9109312gingals
gingers94118642gingers
ginkgo12334942ginkgo_
ginkgoes14323742ginkgoes
ginks104319562gin_k_s
gringos936672gring_os
jingko18505372jingko_
jingkoes20273722jingkoes
pingos95317672ping_os
pinkos125313872pin_kos
agings86312673aging__s
anglos74413913_anglos
bangkok1341793bangkok
bangkoks1441843bangkoks
bigos85020013bi_g_os
bingers104519993bingers
binges93923123bing_es
bingo86020093bing_o_
bingoes104013983bingoes
bongos95316653bong_os
bunkos124210323bun_kos
congos94219883cong_os
dineros83812333dineros
dingers94321383dingers
dinges83825423ding_es
dingeys12458403dingeys
dingies93618243dingies
dingles93818323dingles
dingo74720793ding_o_
dingoes94114833dingoes
dings76331403ding__s
dingus83611843ding_us
dinks105927953din_k_s
dinos65428063din__os
eringos836913ering_os
fingers113418433fingers
finks125424223fin_k_s
finos86226953fin__os
gangers94418603gangers
gangs76222583gang__s
gangues9149753gangues
geckos13457433g_eckos
genros74211333gen_ros
gentoos838633gentoos
gigas75415583gi_g_as
giggles103312933giggles
giglot84013133gi_glot
giglots9367863gi_glots
gigolos934693gigolos
gigot74023073gi_g_ot
gigots83911953gi_gots
gigs66631193gi_g__s
gigues8129003gi_gues
gingal81010153ging_al
gingall9117333gingall
gingalls1096433gingalls
gingeli9286153gingeli
gingelis10247093gingelis
gingely12378213gingely
ginger84920033ging_er
gingery12368913gingery
gingham1484463gingham
ginghams1573903ginghams
gingili9306033gingili
gingilis10255593gingilis
gingiva1253293gingiva
gink97129533gin_k__
ginners84314223ginners
gins55543963gin___s
ginzo1539613gin_zo_
ginzoes1735433ginzoes
giros65722653gi__ros
gismos957183gi_smos
gitanos837173gitanos
gizmos1844133gi_zmos
gogos77516523g_og_os
goings84911523going__s
gongs74921613gong__s
gregos847533greg_os
gringas938043gring_as
gringo838643gring_o_
gunks104517723gun_k_s
hingers113420213hingers
hinges105121033hing_es
infos84311673_in_fos
ingles74420873_ingles
ingot61221063_ing_ot
ingots7912063_ingots
inks86926503_in_k_s
intros64215773_intros
irokos1037233_irokos
jingals1588073jingals
jingles153816383jingles
jingo134615213jing_o_
jingoes153811443jingoes
jinks165019333jin_k_s
kingdom1543543kingdom
kingdoms1643693kingdoms
kingpost1544423kingpost
kings105825573king__s
kinks84926093kin_k_s
kinos96626153kin__os
lingams104510193lingams
lingas75116573ling_as
lingcod1143683lingcod
lingcods1243943lingcods
lingers84223303lingers
lingo66022113ling_o_
lingoes84014693lingoes
lings67135773ling__s
links96430193lin_k_s
linos55631503lin__os
mangos94319343mang_os
mingles103719003mingles
minkes124618783min_kes
minks115829273min_k_s
mongos94318623mong_os
mungos94311373mung_os
oinks94819913oin_k_s
olingos846013oling_os
pengos94612413peng_os
pingers104020743pingers
pingo87122713ping_o_
pingoes105116523pingoes
pings85830883ping__s
pinko115618253pin_ko_
pinkoes135512313pin_koes
pinks115729383pin_k_s
pintos86021293pin_tos
ringers83922953ringers
rings65029173ring__s
ringtoss944203ringtoss
rinks94827103rin_k_s
sickos125112033si_ckos
siglos7311473si_glos
singers83824703singers
singes74326853sing_es
singles83520433singles
sings65532703sing__s
sinks95529183sin_k_s
stingos8459453sting_os
tangos74216323tang_os
tinges74722343ting_es
tingles83818323tingles
tings65329213ting__s
vinos84723073vin__os
wingbow1643773wingbow
wingbows1743983wingbows
wingers113921483wingers
wings95727243wing__s
winks125325433win_k_s
winos84625043win__os
zingers173514853zingers
zings154620893zing__s

Search took 7 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 Filter1786911340270.406440125.6
2DLD Change Limit1340271596.47020715.1
3Display Results1591590.0463456.5
 (SQL Overall)1786911596.92225814.9
 
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.