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

110 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
convoking193574(None) 
convoying1835981convoying
condoling13510372condoling
condoning1339782condoning
conking143618452con__king
connoting12310022connoting
consoling12310872consoling
convening15311192convening
conveying1838322conveying
convolving1944412convolving
cooking143818972co__oking
invoking1635652_invoking
noncoking1646812noncoking
nonvoting1346902nonvoting
bonking144116373bon__king
booking143618383bo__oking
cannoning1237323cannoning
canoeing11310213can_oeing
cantoning12310883cantoning
canvasing1546433canvasing
canyoning1536873canyoning
censoring1238783censoring
choking173911943c__hoking
clonking153810153clon__king
cocking163619983co__cking
cocooning1447023cocooning
coevolving1942353coevolving
coking134523883c___oking
coloring11414843co_loring
comaking1739993co_making
commoving1944983commoving
composing16179843composing
concaving1737353concaving
conceding1559343conceding
concocting1448413concocting
conducing1537693conducing
confiding1638333confiding
confining1539993confining
conforming1847373conforming
confusing1537333confusing
confuting1539093confuting
congaing1239823con_gaing
congeeing1337903congeeing
conglobing1644093conglobing
coning94331823con___ing
conjoin1638203conjo_in_
conjoining2046103conjoining
conjoins1738133conjo_ins
conjoint17410373conjo_int
conjuring1937913conjuring
conning103718753con__ning
conniving1537093conniving
consorting13410743consorting
consuming1437913consuming
contorting13410103contorting
contouring1347013contouring
contusing1239143contusing
convecting18310433convecting
conventing16311543conventing
converging1758093converging
conversing16310543conversing
converting16313133converting
convicting1847583convicting
convincing1845343convincing
convoke16207173convok__e
convoked18236163convok_ed
convoker17226903convok_er
convokers18246103convokers
convokes17247703convok_es
convoluting1744203convoluting
convulsing1645383convulsing
cooing94024923co__o_ing
cookings15358603co__okings
cooling103422573co__oling
cooping123918933co__oping
cordoning1338063cordoning
corking143018823co__rking
cornrowing1643613cornrowing
corroding1337943corroding
cottoning1237343cottoning
couponing1446293couponing
covering142215723co_vering
coveting141912303co_veting
coving124321523co_v__ing
cowboying2043183cowboying
crooking153611343c_rooking
evoking1536413__evoking
honking153414793hon__king
honoring12310473hon_oring
hooking153716693ho__oking
konking113510213kon__king
looking123415043lo__oking
monokine1448483mon_okine
noncaking1646683noncaking
noncoding1347673noncoding
nonloving1345413nonloving
nonmoving1545103nonmoving
nonsmoking1743713nonsmoking
nonworking1844213nonworking
oncoming1338353_oncoming
ongoing938793_ongo_ing
onlooking1444453_onlooking
provoking1935133provoking
reevoking1734223reevoking
reinvoking1843253reinvoking
revoking1637803_revoking
rooking123517363ro__oking
snooking133010583_snooking
unyoking1636183_unyoking
zonking21359113zon__king

Search took 8 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 Filter1786911486410.436409841.7
2DLD Change Limit1486411107.22020587.4
3Display Results1101100.0462391.3
 (SQL Overall)1786911107.70223200.6
 
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.