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 “vermuth” 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
vermuth154353(None) 
vermouth1643761vermouth
vermuths1642601vermuths
overmuch1844082overmuch
permute1138792permute
vermouths1742782vermouths
azimuth2141843azimuth
berth104917883ber__th
besmut10310653besmut_
besmuts1134683besmuts
bismuth1443723bismuth
cermet10321153cermet_
cermets1139713cermets
drouth104410103_drouth
fermata12278143fermata
fermate122813003fermate
hermit11519443hermit_
hermits12312143hermits
overcut12310423overcut_
overcuts1337513overcuts
overlush1445273overlush
overmatch1944243overmatch
permit10321683permit_
permits11314003permits
permuted1336713permuted
permutes1238713permutes
reroute7313963reroute
routh86423073__routh
ruth76825993__r_uth
termite9313893termite
truth85214153_tr_uth
veloute1037733veloute
verdure11287773verdure
verist93823893verist_
verists103613673verists
verite94323443ver_ite
verity123714853ver_ity
vermeil1285223vermeil
vermes115019143verm_es
vermian12329713vermian
vermin113414523verm_in
vermis114214963verm_is
vermoulu1342383vermoulu
verruca1243713verruca
verset94327323verset_
versets103913103versets
verst84429373ver_st_
verste94515633ver_ste
versts93914733ver_sts
versus94211143versu_s
vert77249373ver__t_
verts85724733ver__ts
vertu85017613ver__tu
vertus94613603vertu_s
vervet124619063vervet_
vervets13419753vervets
warmouth1644143warmouth
warmth1477933warm_th
zeroth1837963zer_oth

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.406440125.6
2DLD Change Limit134027597.04619021.7
3Display Results59590.0331787.9
 (SQL Overall)178691597.48523873.2
 
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.