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

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

102 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
conga8541987(None) 
congas94417031congas
conge85227591conge
congo85623131congo
donga76718421donga
tonga65619701tonga
anga56831362_anga
bong75633412bong_
bongo85720942bongo
bongs87828422bongs
canna75919332canna
coala77521122coala
cobia94117512cobia
cobra95214402cobra
coca88030642co_ca
cocoa98517882cocoa
coda77029352co_da
cog69552902co_g_
cognac1157272cognac
cogs77340032co_gs
coign85013912coign
cola66541392co_la
colza165112982colza
coma87134852co_ma
comma114514792comma
con510268022con__
conch124620072conch
concha134213282concha
condo85322592condo
cone67256962con_e
coned86040052coned
cones76457422cones
coney105932882coney
confab1347062confab
congaed11399742congaed
congeal104011682congeal
congee96024472congee
conger95024272conger
conges94928172conges
congii957362congii
congos94219882congos
congou94313242congou
coni65534802con_i
conic95329792conic
conin76232722conin
conk106531442con_k
conks115525702conks
conky145818742conky
conn66229132con_n
conns75024232conns
cons66057692con_s
conte76633202conte
conto76027172conto
contra83314702contra
conus76726532conus
cony96537832con_y
copra98115462copra
corgi8316082corgi
coria75828322coria
cornea84018932cornea
cornua85411902cornua
costa75523732costa
cotinga10348022cotinga
cotta75818572cotta
cougar958782cougar
cough115819642cough
coxa136922962co_xa
dona55529632don_a
dong66031652dong_
dongas84914612dongas
dongs76525812dongs
donna66215032donna
fanga96119632fanga
gong66827192gong_
gongs74921612gongs
gonia64117532gonia
honda9414982honda
hong85833952hong_
hongi96715872hongi
hongs95126202hongs
linga66820822linga
long56933342long_
longan75612362longan
longe66626462longe
longs65527062longs
manga85026212manga
mongo810122412mongo
nona46929062non_a
nongay10169152nongay
panga85323542panga
pong76231142pong_
pongs85526342pongs
sanga66023802sanga
song55133672song_
songs67725552songs
tanga64923712tanga
toga57027412to_ga
tong56434362tong_
tongas74315532tongas
tongs65928472tongs
yoga87418052yo_ga
zona136321962zon_a

Search took 2 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 Filter178691538000.313570897.8
2DLD Change Limit538001021.61033416.1
3Display Results1021020.0462217.4
 (SQL Overall)1786911021.96990752.2
 
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.