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

96 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
vitesse104458(None) 
vitesses1136331vitesses
finesse10187642finesse
vinasse1044512vinasse
biters83925243biters_
bites75641173bite_s_
citers85022983citers_
cites74435593cite_s_
cutesie937963cutesie
dieses75218693di_eses
disease83213843disease
diseuse83110723diseuse
dites66339153dite_s_
diverse11429993diverse
evites94916473evite_s_
fesse86116333__fesse
finessed12136793finessed
finesses111912343finesses
fitness10299393fitness_
fitnesses12219373fitnesses
gites65630183gite_s_
hitless103211193hitless_
idlesse834193idlesse
intense72511903intense
itemise997453_itemise
items7499613_items_
jesse126012833__jesse
kineses113111253kineses
kiters105218593kiters_
kites95432543kite_s_
license9148423license
liters65429883liters_
metisse936503metisse
mimeses1139073mimeses
misease92713043misease
miters84328783miters_
mites75141803mite_s_
mitises9315543mitises
mitoses9312183mitoses
niterie7313743niterie
niters64624213niters_
nites55736343nite_s_
politesse1143673politesse
rites54442553rite_s_
sites56045433site_s_
situses72710493situses
tasse54821843__tasse
tease55428713__tease
tense55225843__tense
terse55026823__terse
titers64526413titers_
verse84723583v__erse
vessel937953v__essel
vibes104719953vibe_s_
vices105725533vice_s_
victress1344523victress_
victresses1544973victresses
videos104911373videos_
vidette1167543vidette
viers85621953vi_ers_
vies75238623vi_e_s_
views11489643vi_ews_
vilest9416843vile_st
villose1038053villose
vinasses1135703vinasses
vines85137643vine_s_
vipers114914533vipers_
vireos94212453vireos_
vires84529683vire_s_
viroses10310533viroses
virtuose1143183virtuose
viruses1039413viruses
viscose1237863viscose
vise75632673vi___se
vises84427773vise_s_
vitae84217633vit__ae
vitalise11310743vitalise
vitals94514303vitals_
vitiate103412953vitiate
vitrine102511363vitrine
vittae93911003vit_tae
vittate10409733vittate
vittle94711753vit_tle
vittles103211113vittles
vivers124717363vivers_
vixens16286203vixens_
voters95017443voters_
votes84627083vote_s_
votress1035483votress_
votresses1236503votresses
wites85536963wite_s_
witless103310983witless_
witness103010013witness_
witnessed13214723witnessed
witnesser12224533witnesser
witnesses12219923witnesses

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 Filter1786911340270.423422437.4
2DLD Change Limit134027967.26618445.8
3Display Results96960.0303200.0
 (SQL Overall)178691967.71923149.5
 
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.