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

67 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
verandas124623(None) 
veranda1156321veranda_
verandah1543621verandah
verandahs1642291verandahs
vandas103915992v__andas
verandaed1443142verandaed
bandas95120543__bandas
bermudas1342973bermudas
brands95118943_brand_s
demands114311413demand_s
deranges1039973deranges
desands94810163desand_s
elands74914773_eland_s
errands847603errand_s
geladas936313gela_das
geranial949283geranial
geranials1045913geranials
gerardias1144403gerardias
gerunds935183gerund_s
grandad1038453_grandad
grandads1136553_grandads
grandam1139393_grandam
grandams1237123_grandams
grandmas1236923_grandmas
grandpas1236003_grandpas
grands84218243_grand_s
heralds1137713herald_s
hernias10310773her_nias
marantas10310023marantas
operands1146813operand_s
overhands16227803overhand_s
overlands13218883overland_s
pandas95521963__pandas
piranas9912603piran_as
piranhas13135873piranhas
puranas9712643puran_as
randan7315253__randan
randans8313213__randans
rands65930453__rand_s
relands85214883reland_s
remands104914883remand_s
seringas9339003seringas
strands83711953strand_s
tarantas839193tarantas
uranias72113813_uranias
vanda94515923v__anda_
vandal103713833v__andal
vandals113211663v__andals
varnas94212823var_n_as
vedalias1245153vedalias
veenas91410413ve_en_as
vegans103910853vegan__s
vends95520893ve__nd_s
verandahed1851813verandahed
veratrias1246563veratrias
verbenas1345343verbenas
verbids13259203verbid_s
verglas1137813ver_glas
veritas103012753ver_itas
vernal93514213ver_n_al
veronicas1446393veronicas
verrucas1343923verrucas
versants1137783versan_ts
viands1047813v_iand_s
wakandas1643413wakandas
zenaidas18513663zenaidas
zenanas16286233zenan_as

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 Filter1786911461620.406440125.6
2DLD Change Limit146162676.57622226.6
3Display Results67670.0164187.5
 (SQL Overall)178691676.99825534.6
 
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.