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

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

56 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
velites10341730(None) 
elites66027121_elites
pelites93821991pelites
verites103822261verites
aplites9314932aplites
belies84631052beli_es
blites84721212_blites
cerites94823432cerites
delates83526282delates
deletes83117932deletes
delimes10314192delimes
elates65032362_elates
elides74420692_elides
elite56230182_elite_
elutes64020312_elutes
evites94916482_evites
felines104718072felines
felsites1138072felsites
flites95122442_flites
gelates83219592gelates
halites103221192halites
helices12313722helices
helixes1739132helixes
illites72415012illites
iolites73819482iolites
lenites7818442lenites
oolites72817842oolites
pelite84323002pelite_
penlites10312272penlites
perlites10316362perlites
petites93820202petites
recites93524592recites
relates73731442relates
relies65036422reli_es
relines75331322relines
relives104619442relives
resites74027802resites
valines104520212valines
valises103516272valises
vegies104314272vegi_es
velate93720142velate_
veldts10417752veldt_s
veliger1137312veliger
veligers1237022veligers
veloutes1136152veloutes
velures1039092velures
velvets13326692velvets
venines103516612venines
venires103012452venires
veritas103012752veritas
verite94323442verite_
verities111418042verities
verstes104014282verstes
voltes94915582vol_tes
volutes102710982volutes
zeolites1738382zeolites

Search took 4 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 Filter1786911076710.373479064.3
2DLD Change Limit107671563.17333933.5
3Display Results56560.0134307.7
 (SQL Overall)178691563.55950208.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.