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

153 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
gigolo83653(None) 
gigolos934691gigolos
giggle94313512giggle
giggly12518702giggly
giglot84013132giglot
gigot74023072gigo_t
gigots83911952gigots
igloo6410492_igloo
aioli5318313ai_oli
anglo65215363ang_lo
argol65317263argol_
argols74514613argols
bicolor1145613bicolor
bifold1237223bifold
bigly114814753big_ly
bigos85020013bigo_s
bigot84828323bigo_t
bigots95015133bigots
bolo65535953__bolo
cholo105217973_cholo
cibol9512023cibol_
cibols1039523cibols
citola838393citola
citole8311503citole
diabolo1065483diabolo
diglot83014333diglot
diol57329133di_ol_
diols65521013di_ols
dipole91112853dipole
eidola737683eidola
eidolon844913eidolon
fillo84319783fi_llo
filo76034283fi__lo
gaggle93412623gaggle
gaol56925413g_aol_
gaols66717573g_aols
gazoo153112873gazo_o
giaour735363giaour
gig56040753gig___
giga66720943gig__a
gigaflop1551353gigaflop
gigas75415583gig_as
gigaton946343gigaton
gigged104112293gigged
giggled114010073giggled
giggler101029883giggler
giggles103312933giggles
gighe10139733gig_he
giglet83920273giglet
giglots9367863giglots
gigs66631183gig__s
gigue71210673gig_ue
gigues8128993gigues
gild65526513gi__ld
gill56336183gi__ll
gills64728193gi_lls
gilly94321633gi_lly
gilt56348543gi__lt
gimel8313353gimel_
gimels938893gimels
gingal81010143gingal_
gingall9117323gingall
gingals9109303gingals
gingeli9286143gingeli
gingely12378193gingely
gingili9306023gingili
gingko12376033gingko
ginkgo12334943ginkgo
ginzo1539613gi_nzo
gipon84212413gipo_n
gipons9389603gipons
girdle82110463girdle
girl56226553gi_rl_
girls64518393gi_rls
girly94415293gi_rly
giro55828633gi__ro
girolle835793girolle
giron66118993giro_n
girons75014373girons
giros65722653giro_s
girosol885303girosol
gismo848863gi_smo
gitano738043gitano
gizmo1756013gi_zmo
gobo76126893__gobo
goggle94511573goggle
goggly12337053goggly
gogo69722833__gogo
gogos77516523gogo_s
gold65430163__gold
golf85731183__golf
goo47754773__go_o
googly11417883googly
googol835843googol_
googols935483googols
guggle94110433guggle
higgle113811743higgle
highly1636823highly
hillo84721653hi_llo
idol56818633_idol_
idols65514133_idols
igloos738033_igloos
iglu510814783_ig_lu
iroko939663_iroko
isolog737403_isolog
jiggle153811993jiggle
jiggly18378713jiggly
kilo86028663ki__lo
kimono12105413kimono
kolo87026223__kolo
ligula7359673ligula
ligule74010833ligule
lilo46731563li__lo
miggle104012113miggle
milo65536093mi__lo
nicol71113293nicol_
nicols8810243nicols
niello636603niello
niggle83612823niggle
niggly11418913niggly
nolo46229313__nolo
ovolo8339173_ovolo
piccolo1354403piccolo
pignoli1045443pignoli
pigout9314613pigout
pinole83218783pinole
polo66236633__polo
righto104111093righto
rigor62714053rigo_r
rigors72813713rigors
rigour7258023rigour
rugola736293rugola
sigil63515503sigil_
sigils73912363sigils
sigla64515203sig_la
sigloi737733sigloi
siglos7311463siglos
silo46037913si__lo
solo45538943__solo
tiglon737913tiglon
tigon63914443tigo_n
tigons74112253tigons
timolol944113timolol
vigil94313003vigil_
vigils104210193vigils
vigor92612423vigo_r
vigors102911483vigors
vigour10256803vigour
viol76523593vi_ol_
viola85915543vi_ola
viols86118103vi_ols
wiggle113713013wiggle
wiggly14559683wiggly

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127161535.95318934.3
3Display Results1531530.0632428.6
 (SQL Overall)1786911536.15629027.1
 
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.