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

152 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
gingeli928615(None) 
gingelis10247091gingelis
gingelli10304391gingelli
gingely12378211gingely
gingili9306031gingili
gingal81010152gingal_
gingall9117332gingall
gingals9109312gingals
gingeley13294672gingeley
gingelies11277502gingelies
gingellis11244202gingellis
gingelly13305692gingelly
ginger84920032ginge_r
gingerly13315302gingerly
gingers94118642gingers
gingery12368912gingery
gingilis10255592gingilis
gingilli10274412gingilli
ainsell796393ainsell
angel65019573_angel_
angelic1039623_angelic
angels74416173_angels
binge85125513binge__
binged105920823binge_d
binger94923453binge_r
bingers104519993bingers
binges93923123binge_s
cingula10327173cingula
dinge75627303dinge__
dinged95221783dinge_d
dinger85323673dinge_r
dingers94321383dingers
dinges83825423dinge_s
dingey114914053dinge_y
dingeys12458403dingeys
dingily1238103dingily
dingle84317073ding_le
dingles93818323dingles
finely123011563fin_ely
finger104920333finge_r
fingers113418433fingers
ganged94619203gange_d
ganger83721473gange_r
gangers94418603gangers
ganglia946613gang_lia
gangly113911593gang_ly
gangrel996143gangrel_
gangrels1094973gangrels
gigged104112293gigge_d
giggle94313513gi_ggle
giggled114010073giggled
giggler101029883giggler
giggles103312933giggles
giggly12518703gi_ggly
giglet83920273gi_glet
gigolo836533gi_golo
gimel8313353gi_mel_
gimels938893gi_mels
gingalls1096433gingalls
gingeleys14272893gingeleys
gingellies12233923gingellies
gingered11127743gingered
gingering1238873gingering
gingham1484463gingham
gingillis11213743gingillis
gingiva1253293gingiva
gingko12376033ging_ko
gingkos13405343gingkos
ginned83813983ginne_d
ginner73915823ginne_r
ginners84314223ginners
ginseng933433ginseng
gonged97115913gonge_d
grindelia1142293grindelia
gunnel73411053gunnel_
gunnels8358563gunnels
gunsel7339853gunsel_
gunsels8338133gunsels
hinge95323453hinge__
hinged114618923hinge_d
hinger104723333hinge_r
hingers113420213hingers
hinges105121033hinge_s
ingest73119003_ingest
ingle64120433_ing_le
ingles74420873_ingles
ingulf10310353_ingulf
jingal1498593jingal_
jingall1566173jingall
jingals1588073jingals
jingle143815223jing_le
jingled164111063jingled
jingler154311093jingler
jingles153816383jingles
jingly174111933jing_ly
kinged124215293kinge_d
kinglet123114043kinglet
kingly143511303king_ly
linger75226003linge_r
lingerie959203lingerie
lingers84223303lingers
lingula8428803lingula
lintel64013993lintel_
lintels73311163lintels
mangel94017543mangel_
mangels103614493mangels
mingle93518783ming_le
mingled113612733mingled
mingler104213843mingler
mingles103719003mingles
pignoli1045443pignoli
pinged104321383pinge_d
pinger94324093pinge_r
pingers104020743pingers
ridgel8399973ridgel_
ridgels9348023ridgels
ringed84623843ringe_d
ringent8315153ringent
ringer74526063ringe_r
ringers83922953ringers
ringlet82818173ringlet
singe65731133singe__
singed85422293singe_d
singer74227313singe_r
singers83824703singers
singes74326853singe_s
single74520603sing_le
singled93914683singled
singles83520433singles
singlet84120113singlet
singly104015853sing_ly
tangelo837043tangelo
tinge64626633tinge__
tinged84220813tinge_d
tinges74722343tinge_s
tingle74319073ting_le
tingled93712803tingled
tingler83613343tingler
tingles83818323tingles
tingly103815983ting_ly
tinsel639443tinsel_
tinsels738373tinsels
winged114620833winge_d
wingedly1644013wingedly
winger104125443winge_r
wingers113921483wingers
winglet113115983winglet
zingani1744813zingani
zingari1745483zingari
zinged174414623zinge_d
zinger163816703zinge_r
zingers173514853zingers

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.470380193.6
2DLD Change Limit1340271526.29621287.6
3Display Results1521520.0602533.3
 (SQL Overall)1786911526.82626178.0
 
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.