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

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
kavasses154430(None) 
kvasses14365501k_vasses
amasses93912852_amasses
avgasses1284192_avgasses
badasses1136172badasses
bagasses1136312bagasses
camasses12388972camasses
canvasses14286042canvasses
harasses11311032harasses
karosses1236492karosses
kavass13517302kava_s_s
kvases13467102k_va_ses
lavashes1445572lavashes
pavisses13397102pavisses
abases85720773_aba_ses
abashes12510373_abashes
abysses1234863_abysses
admasses1135413admasses
amassed10388633_amassed
amasser9418733_amasser
amassers10337843_amassers
asses55629283___asses
avenses1049643_avenses
avgases11106313_avgases
avulses1035433_avulses
baases85218013ba_a_ses
babassus1243063babassus
badassed1244273badassed
bagasse1035143bagasse_
balases93815433bala_ses
basses85428303__basses
biasses94911653_biasses
brasses93818353_brasses
bypasses1533833bypasses
calashes13310543calashes
camases114216343cama_ses
canvases13349523canva_ses
canvassed15274043canvassed
canvasser14274263canvasser
canvassers15273583canvassers
carcasses1337483carcasses
caresses10314063caresses
chasses124017503_chasses
classes94717943_classes
crevasses1444143crevasses
degasses10278363degasses
eyasses10388023_eyasses
favuses1336183fav_uses
frasses104314513_frasses
gamashes1456953gamashes
gasses75724783__gasses
gausses8308693ga_usses
gavages1237683gava_ges
glasses84414273_glasses
grasses84117343_grasses
harassed1237113harassed
harasser1137043harasser
harassers1246203harassers
hardasses1346453hardasses
impasses12257523impasses
jackasses2243713jackasses
karaokes1145013karaokes
karates115617473kara_tes
katharses1643873katharses
kavas125919953kava___s
kinases113511123kina_ses
kisses104217333k__isses
kumisses1443583kumisses
kvass12507273k_va_s_s
lasses64827593__lasses
lavaboes1344433lavaboes
lavages1138603lava_ges
lavishes1457403lavishes
malaises10312333malaises
masses85028713__masses
matrasses1157293matrasses
mavises122812993mav_ises
megasses11307743megasses
molasses1037233molasses
morasses1038903morasses
passes86030473__passes
pavanes123612653pava_nes
pavises125315493pav_ises
pavisse12546813pavisse_
quasses16209503_quasses
ravages1139403rava_ges
ravishes1478043ravishes
repasses101810373repasses
rubasses1035493rubasses
sasses64124393__sasses
savages1139973sava_ges
savates10312953sava_tes
strasses81311443strasses
tasses64826763__tasses
trasses74819323_trasses
valses94514613__valses
vases84626263__va_ses
vavasors14153653vavasors
vavassor1441723vavassor
vavassors1541843vavassors
vinasses1135703vinasses
wrasses103812593_wrasses

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.406440125.6
2DLD Change Limit1461621027.23320207.7
3Display Results1021020.0462217.4
 (SQL Overall)1786911027.68523251.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.