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

133 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
vitesses113633(None) 
vitesse1044581vitesse_
finesses111912342finesses
fitnesses12219372fitnesses
victresses1544972victresses
vinasses1135702vinasses
votresses1236502votresses
witnesses12219922witnesses
abbesses1235333abbesses
accesses1287493accesses
actresses1137933actresses
aptnesses11168993aptnesses
assesses737383assesses
aviatresses1483003aviatresses
avidnesses1436463avidnesses
biasses94911653bi_asses
bicepses1443873bicepses
bignesses1267963bignesses
blesses93812393_blesses
caresses10314063caresses
cesses84221363__cesses
chesses124112633_chesses
citruses1037483citruses
cresses94219813_cresses
dieses75218693di_e_ses
digresses1137863digresses
dimnesses1238213dimnesses
diseases92415813diseases
diseuses93112763diseuses
disses75225963di__sses
distresses1148853distresses
dresses83716173_dresses
duresses939173duresses
editresses1165073editresses
egresses949443egresses
esses56422973___esses
evilnesses1346003evilnesses
excesses1736753excesses
fatnesses121710463fatnesses
fesses94820253__fesses
finesse10187643finesse_
finessed12136793finessed
giantesses1143513giantesses
guesses8169373_guesses
heiresses1236963heiresses
hipnesses1436753hipnesses
hisses94719353hi__sses
hostesses1247173hostesses
hotnesses1238903hotnesses
icinesses11310073icinesses
idlesses936003idlesses
ileuses738673_ileuses
itemises1087693_itemises
jesses135215953__jesses
kineses113111253kine_ses
kirmesses15253903kirmesses
kisses104217333ki__sses
licenses10118923licenses
lionesses939433lionesses
liteness82213213liteness
litenesses10513023litenesses
litmuses1044463litmuses
loesses7310033_loesses
messes84924343__messes
metisses1036833metisses
mimeses1139073mime_ses
mimesises1345363mimesises
miseases102614343miseases
misses85130873mi__sses
mistresses1247993mistresses
mitises9315543mit_ises
mitoses9312183mit_oses
nesses64718323__nesses
niteries8318383niteries
obsesses1036223obsesses
ogresses938473ogresses
osteoses839033osteoses
ovotestes1242533ovotestes
oyesses1037333_oyesses
patnesses111611793patnesses
pisses84525083pi__sses
poetesses1137233poetesses
politesses1245363politesses
presses93523153_presses
recesses10312323recesses
sisses64520603si__sses
situses72710493sit_uses
stresses81112493stresses
tasses64826763__tasses
teases65426273__teases
tenses64722553__tenses
testes65125823__testes
tigresses1046403tigresses
titanesses1037253titanesses
tosses65225393__tosses
tresses73719543_tresses
tusses64921243__tusses
uptosses1043973uptosses
vainnesses1337343vainnesses
vastnesses13128203vastnesses
verses94223763v__erses
vessel937953v__essel
vessels1035933v__essels
viceless1337983viceless
videttes1266333videttes
vileness1139983vileness
vilenesses13310223vilenesses
vinasse1044513vinasse_
vineries112716043vineries
viroses10310533vi_roses
viruses1039413vi_ruses
viscoses1338343viscoses
vises84427773vi___ses
vitalises12310093vitalises
vitalnesses1456273vitalnesses
vitellus1144143vitellus
vitelluses1352013vitelluses
vitiates112311433vitiates
vitreouses1343003vitreouses
vitrines112610913vitrines
vittles103211113vit_tles
voidnesses1436843voidnesses
votaresses1343913votaresses
voteless1137493voteless
waitresses1345063waitresses
wavinesses16199283wavinesses
wetnesses12208213wetnesses
wiseasses1244043wiseasses
wisses94619603wi__sses
witnessed13214723witnessed
witnesser12224533witnesser
witnessers13173103witnessers
yesses93615813__yesses

Search took 9 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.846211218.7
2DLD Change Limit1461621337.76318828.0
3Display Results1331330.0462891.3
 (SQL Overall)1786911338.65520646.0
 
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.