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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

90 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
canvasing154643(None) 
canvassing1643801canvassing
canaling112016412can_aling
abasing10610673_a_basing
advising1336153_advising
aliasing9310073_aliasing
anearing9413973_anearing
anviling1239743_anviling
bandaging1436063bandaging
banjaxing2642553banjaxing
cabbaging1744093cabbaging
callusing1236173callusing
calving134113503calv__ing
campusing1654913campusing
canakin131810833can_akin_
canakins142010463can_akins
canalising1349363canalising
canalling1239553canalling
canceling14310163canceling
candling122313873can_dling
candying15188993can_dying
caning94128623can___ing
cankering162110793cankering
cannabin1266433cannabin_
cannabins1365783cannabins
canning103620133can__ning
cannoning1237323cannoning
canoeing11310213can_oeing
canonising1346583canonising
canopying1745063canopying
cantering122417373cantering
canting104725903can__ting
cantoning12310883cantoning
canulating1349543canulating
canvas113813333canvas___
canvased14246213canvas_ed
canvaser13276553canvas_er
canvasers14265353canvasers
canvases13349513canvas_es
canvaslike1951883canvaslike
canvass12376873canvas__s
canvassed15274033canvassed
canvasser14274253canvasser
canvasses14286033canvasses
canyoning1536873canyoning
caravaning1644423caravaning
caressing1238803caressing
carousing1237893carousing
carving133916773carv__ing
cascading1545673cascading
caseating12311743caseating
casing94829103c___asing
catfacing1744553catfacing
caucusing1443803caucusing
causing103614413ca__using
cavatina1347333ca_vatina
cavatine13310323ca_vatine
caveating1539293caveating
caviling14310113ca_viling
caving124822613ca_v__ing
ceasing104118263c__easing
censing104215263cen__sing
censusing1244813censusing
chasing133715893c__hasing
concaving1737353concaving
confusing1537333confusing
congaing1239823conga_ing
contusing1239143contusing
convening15311193convening
conversing16310543conversing
conveying1838323conveying
convoking1935743convoking
convoying1835983convoying
convulsing1645383convulsing
creasing113314443c_reasing
crevassing1643533crevassing
encasing11610823_encasing
fantasying1743563fantasying
hangaring1438033hangaring
incasing11610603_incasing
invading1336263_invading
managing1239093man_aging
mandating1339773mandating
pancaking1836383pancaking
ravaging1346323ra_vaging
salvaging1465283salvaging
sandaling112010563sandaling
savaging1356673sa_vaging
scandaling14195453scandaling
uncasing11511003_uncasing

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.423422437.4
2DLD Change Limit148641907.04621095.8
3Display Results90900.0461956.5
 (SQL Overall)178691907.51523777.9
 
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.