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

82 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
verites10382226(None) 
cerites94823431cerites
velites103417301velites
veritas103012751veritas
verite94323441verite_
verities111418041verities
verstes104014281verstes
aerates74627502aerates
aeries64737782aeri_es
barites94322342barites
berates94126882berates
berimes115216642berimes
cerates95428252cerates
cerises94722252cerises
cerite84724872cerite_
certes84623082cer_tes
curites93919862curites
derates84028892derates
derides93420852derides
derives114017812derives
elites66027122_elites
evites94916482_evites
ferities111416722ferities
ferrites112312832ferrites
frites94922482_frites
kernites1269112kernites
lenites7818442lenites
merises93421422merises
merited10313852merited
merits8320872merit_s
norites74018802norites
overbites14310982overbites
pelites93821992pelites
peritus9311802peritus
perlites10316362perlites
petites93820202petites
pyrites12812202pyrites
recites93524592recites
rerises73525882rerises
resites74027802resites
rewrites11311062rewrites
rites54442552__rites
seriates82620682seriates
series64540972seri_es
serines74229542serines
sorites73825242sorites
sprites94220332sprites
tergites9310542tergites
termites10313692termites
variates111214992variates
varices123313572varices
varies94330872vari_es
veeries102916892veeri_es
vegies104314272vegi_es
venines103516612venines
venires103012452venires
verbiles1338922verbiles
verditer1236222verditer
verditers1344992verditers
verges104320182ver_ges
verier94620962veri_er
veriest103719132veri_est
verifies141313482verifies
verisms123011252verisms
verists103613672verists
veritates12310972veritates
verity123714852verit_y
vermes115019142ver_mes
vernixes1836052vernixes
verses94223762ver_ses
versets103913102versets
versines112213822versines
verste94515632verste_
versts93914732verst_s
vertex1637372ver_tex
vertices13612282vertices
verts85724732ver_t_s
vertus94613602ver_tus
verves124617882ver_ves
vervets13419752vervets
writes94420332_writes
yperites13310152yperites

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.440406115.9
2DLD Change Limit107671823.14034290.1
3Display Results82820.0302733.3
 (SQL Overall)178691823.61049498.9
 
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.