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

127 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
convoker1722690(None) 
convoke16207171convoke_
convoked18236161convoked
convokers18246101convokers
convokes17247701convokes
condoler113412122condoler
condoner112913412condoner
conker124721552con__ker
consoler102812612consoler
convener132913162convener
conveyer16278142conveyer
convoyed17225552convoyed
cooker124722452co__oker
invoker1435362_invoker
nonvoter1186892nonvoter
booker124719193bo__oker
canker124422523can__ker
canoer85121073can_o_er
canvaser13276563canvaser
choker154314373c__hoker
cocker144320393co__cker
colorer9312523co_lorer
comaker153410603co_maker
commoner142710633commoner
composer145012953composer
conceder1338743conceder
conciser12310243conciser
concocter1247623concocter
condoes104319203condo_es
condole102914953condole_
condoled123110723condoled
condolers122710573condolers
condoles113015803condoles
condone102616293condone_
condoned122612023condoned
condoners122811513condoners
condones112817393condones
condor94616973condo__r
condores113315643condores
conducer13127373conducer
confer114018683con__fer
confider1438123confider
confiner13311193confiner
conformer1667463conformer
confuter1338513confuter
congener112412203congener
conger95024273con__ger
congoes103617303congo_es
conifer123212643con_ifer
conioses10313313conioses
conjoiner1855933conjoiner
conjurer17117683conjurer
conked135019113con__ked
conkers133721043con__kers
conner84423963con__ner
conniver1337493conniver
connote9311613connote_
connoted1138863connoted
connotes10311453connotes
conquer1838623con_quer
consider11310393consider
console92715983console_
consoled112911453consoled
consolers112510923consolers
consoles103216153consoles
consumer1238503consumer
contour939973conto_ur
convene123314323convene_
convened143412223convened
conveners142911443conveners
convenes132916913convenes
convenor13307613convenor
converser1438093converser
convert123721473conv__ert
converter14311013converter
convex18367743conv__ex
convexes20278273convexes
convey144610223conv__ey
conveyed17247923conveyed
conveyers17267203conveyers
conveyor16245293conveyor
convincer1645833convincer
convoking1935743convoking
convolve1644653convolve
convolved1844083convolved
convolves1745323convolves
convoy14348543convo__y
convoys15267023convo_ys
cooer74831013co__o_er
cooked135921363co__oked
cookers134619463co__okers
cookery164210393co__okery
cookey155414333co__okey
cooler84824713co__oler
cooper104221123co__oper
cooter85128613co__oter
corker124720853co__rker
coroner94218203co_roner
cover105430773co_v__er
coverer123113523co_verer
coveter122912063co_veter
coworker1744683coworker
cowpoke1835103cowpoke_
cowpokes1944573cowpokes
crooker134111093c_rooker
donniker1333923donniker
evoker13467913__evoker
honker134117463hon__ker
honorer1039673hon_orer
hooker134820173ho__oker
invoke1336213_invoke_
invoked1535303_invoked
invokers1534673_invokers
invokes1436383_invokes
ionomer939833ion_omer
looker104816953lo__oker
monicker1635733monicker
moniker1338673mon_iker
monomer11311893mon_omer
nonsmoker1544303nonsmoker
nonvoters12136463nonvoters
nonworker1644823nonworker
onlooker1243473_onlooker
provoker1784913provoker
revoker14419193_revoker
snooker113910303_snooker
yonker134110853yon__ker

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 Filter1786911461620.436409841.7
2DLD Change Limit1461621276.71621763.3
3Display Results1271270.0632015.9
 (SQL Overall)1786911277.21524766.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.