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

252 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
ginzoes173543(None) 
bingoes104013982bingoes
dingoes94114832dingoes
gingkoes14404732gingkoes
ginkgoes14323742ginkgoes
ginzo1539612ginzo__
jingoes153811442jingoes
lingoes84014692lingoes
pingoes105116522pingoes
pinkoes135512312pinkoes
pintoes95117712pintoes
winoes94317012win_oes
winzes184313052winz_es
agnizes17328843agniz_es
banjoes16317313banjoes
benzoles1936993benzoles
benzols1836673benzols
bilboes114410243bilboes
bimboes13498733bimboes
bindles104016453bindles
bines76946793bin__es
binges93923123bin_ges
bingos95514793bingo_s
binocs1039923bin_ocs
bizes165923663bi_z_es
bizones1837823bi_zones
bizzes163910843bi_zzes
bongoes104314113bongoes
bonzes175116103bonz_es
canoes84725883can_oes
canzones1939153canzones
cinches144215773cinches
cineoles10109403cineoles
cineols9128853cineols
cines75239683cin__es
cinques1837333cinques
ciscoes113610733ciscoes
condoes104319203condoes
congoes103617303congoes
diazoles1836323diazoles
didoes85716963di_does
dildoes9229243dildoes
dindles93817243dindles
dines66449153din__es
dinges83825423din_ges
dingies93618243dingies
dingles93818323dingles
dinkies123716033dinkies
dinos65428063din_o_s
diploes101111493diploes
ditzes163212423ditz_es
dizzies16279753dizzies
eringoes937433eringoes
ficoes114613463fi_coes
finales104016013finales
finches153914193finches
fines86644263fin__es
finises10312903finises
finites10315923finites
finos86226953fin_o_s
fizzes174512553fi_zzes
fizzles18339063fizzles
fungoes11388813fungoes
gangues9149753gangues
ganofs104010293gan_ofs
gauzes164710633gauz_es
gazes155425913g_az_es
gazoos163010223g_azoos
geckoes14325793geckoes
genes65133093gen__es
geneses82613523geneses
genies75324943gen_ies
genoas74013623gen_oas
genomes103611703genomes
genoms94412483gen_oms
genres75515623gen_res
genros74211333genro_s
gentes75324163gen_tes
gentles83714343gentles
gentoos838633gentoos
genuses83510883genuses
gessoes838293gessoes
ghazies2036913ghazies
gibbons1234983gibbons
gibbose1244083gibbose
gibbous1265333gibbous
gibes84422523gi__bes
gibsons1045043gibsons
giddies103713363giddies
gies55641423gi___es
giftees11306513giftees
giggles103312933giggles
giglots9367863giglots
gigots83911953gi_gots
gigues8129003gi_gues
gillies84120963gillies
gimmes113010903gi_mmes
gimmies123010113gimmies
gingals9109313gingals
ginger84920033gin_ger
gingers94118643gingers
gingkos13405343gingkos
ginkgos13314183ginkgos
ginks104319563gin__ks
ginned83813983gin_ned
ginner73915823gin_ner
ginners84314223ginners
ginnier8298983ginnier
ginniest92610513ginniest
gins55543953gin___s
gipons9389603gi_pons
gipsies1039903gipsies
girdles92210003girdles
girlies83013703girlies
girons75014373gi_rons
giros65722653gi_ro_s
girshes11248293girshes
gismos957183gismo_s
gites65630183gi__tes
gives95324873gi__ves
gizmos1844133gi_zmos
glazes165315643glaz_es
glitzes17367563glitz_es
glozes164313353gloz_es
gnomes93812973g_nomes
gnoses76515163g_noses
goboes95914443g_oboes
goes55644093g___oes
gonofs10459863gon_ofs
gonzo15310243gonzo__
grazes164519643graz_es
grinches1436943grinches
gringos936673gringo_s
grizzles17286193grizzles
gundogs1034603gundogs
gunites8313123gunites
gunnies83413123gunnies
gustoes879873gustoes
guzzles16328043guzzles
hilloes103815963hilloes
hinges105121033hin_ges
hinnies103615103hinnies
igneous835773igneous
ignites81310583ignites
ignores8269003ignores
inanes62519803_inanes
inches114419673_inches
incogs937903_incogs
incomes11712373_incomes
indies73822783_indies
indoles83716363_indoles
indols74714203_indols
indows104210793_indows
indues73515263_indues
infos84311673_info_s
ingles74420873_ingles
ingots7912063_ingots
inions64417003_inions
inkles103515653_inkles
insoles73516243_insoles
intones7816543_intones
inures63318953_inures
invokes1436383_invokes
jingkoes20273723jingkoes
jingles153816383jingles
jinxes20428233jin_xes
juncoes16338073juncoes
kiddoes13387063kiddoes
kinases113511123kinases
kindles123614843kindles
kines95039133kin__es
kineses113111253kineses
kinos96626143kin_o_s
linages8813173linages
lindies8416583lindies
lines57054573lin__es
linos55631503lin_o_s
lintols7339553lintols
mangoes104316133mangoes
minces104420803min_ces
mines75651953min__es
mingles103719003mingles
minions93314623minions
minkes124618783min_kes
minnies93617363minnies
minnows1234913minnows
minors85117103min_ors
minuses93512703minuses
minutes93513443minutes
minxes154612983min_xes
misdoes10312493misdoes
mizzles17329493mizzles
mongoes103415713mongoes
mungoes103510463mungoes
nines55937343nin__es
ninnies73713613ninnies
ninons64913773nin_ons
noes45845393__n_oes
pinbones1238143pinbones
pinches144117933pinches
pinenes93416673pinenes
pines76048863pin__es
pingos95317673pingo_s
pinholes131810663pinholes
pinions93413603pinions
pinites9319533pinites
pinkies133818263pinkies
pinkos125313873pinko_s
pinnies93318443pinnies
pinoles93418703pinoles
pinones94717073pinones
pinons86019943pin_ons
pinots85920273pin_ots
pintles94118723pintles
pintos86021293pinto_s
pinyons12299003pinyons
pizzles17329273pizzles
rinses64720383rin_ses
ritzes154812943ritz_es
sines55954823sin__es
singes74326853sin_ges
singles83520433singles
sinuous739063sinuous
sinuses73011593sinuses
sizes146727763si_z_es
sizzles15349633sizzles
tines54848423tin__es
tinges74722333tin_ges
tingles83818323tingles
tinkles113713923tinkles
tiptoes939173tiptoes
tizzies15287893tizzies
undoes73917403_undoes
vines85137643vin__es
vinos84723073vin_o_s
vinous93914173vin_ous
vizors18328903vi_zors
winces114819113win_ces
winches154714373winches
windles113518493windles
windows1447743windows
wines85546863win__es
winkles143412773winkles
winnows1334533winnows
winos84625043win_o_s
wintles103414983wintles
winze175014853winz_e_
wizes174723343wi_z_es
wizzes175110773wi_zzes
zincous1837053zincous
zines145232653zin__es
zizzles14307093zizzles

Search took 9 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.343520965.0
2DLD Change Limit1340272527.75017293.8
3Display Results2522520.0763315.8
 (SQL Overall)1786912528.16921874.3
 
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.