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

59 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
verismos1328469(None) 
verismo12276391verismo_
verisms123011251verism_s
verism113214262verism__
verists103613672veris_ts
versos93812802ver_s_os
aristos7312373_aristos
berimes115216643beri_mes
cerises94722253ceris_es
ceriums1139473cerium_s
chrismon1544643chrismon
chrismons1644003chrismons
chrisms1499143chrism_s
chrisoms1566093chrisoms
deisms94411043de_ism_s
derision939073derision
derisions1038843derisions
eringos836913_eringos
gismos957183__gismos
heroisms1338693heroism_s
lyrisms1235653lyrism_s
melismas1245713melismas
merinos9311983meri_nos
merises93421423meris_es
merisis93213173meris_is
ogrisms1036443ogrism_s
perishes13313753perishes
porisms113713453porism_s
primos104514423_pri_mos
prisms104915503_prism_s
purisms114110833purism_s
rerises73525883reris_es
seisms84912143se_ism_s
seriemas1047193seriemas
sexisms16226223sexism_s
trismus935563_trismus
varistor1146393varistor
varistors1246533varistors
venison1036443venis_on
venisons1136133venisons
verifies141313483verifies
verist93823893veris__t
veristic1339883veristic
veritas103012753veri_tas
verites103822263veri_tes
verities111418043verities
vermes115019143ver__mes
vermis114214963ver__mis
versers103813523ver_sers
verses94223763ver_s_es
versets103913103ver_sets
versines112213823versines
version10310923ver_sion
versions11310353versions
verso85314633ver_s_o_
verstes104014283ver_stes
versts93914733ver_s_ts
versus94211143ver_s_us
vertigos1254973vertigos

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.436409841.7
2DLD Change Limit146162597.75018859.6
3Display Results59590.0163687.5
 (SQL Overall)178691598.20221786.3
 
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.