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

55 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
teazelled194374(None) 
teaselled1045151teaselled
teazeled18194231teaze_led
teaseled9186802tease_led
teaseller945222teaseller
teazled17326832teaz__led
tramelled1266222tramelled
travelled1356862travelled
weaselled1344212weaselled
bevelled14327823be_velled
defuelled1443133defuelled
easeled8159863_ease_led
enamelled1244623enamelled
excelled18125703_excelled
expelled1895883_expelled
ferrelled1343943ferrelled
gabelled12317583_gabelled
gavelled13387363_gavelled
gazelle17236333_gazelle_
gazelles18266563_gazelles
gravelled1475553gravelled
jewelled1934343je_welled
kennelled1443513kennelled
kernelled1443743kernelled
labelled11278293_labelled
lapelled11227083_lapelled
levelled12327453le_velled
panelled1138963_panelled
ravelled12419783_ravelled
rebelled113110333re_belled
refelled122810173re_felled
refuelled1364513refuelled
relabelled1342863relabelled
repanelled1343403repanelled
repelled113111593re_pelled
respelled1257073respelled
revelled123712743re_velled
tasselled1044663tasselled
teaseler8176583tease_ler
teasellers1043983teasellers
teazel15368543teaze_l__
teazeling1934543teazeling
teazelling2043803teazelling
teazels16406893teaze_l_s
teazle15329553teaz__le_
teazles16308923teaz__les
tinselled1044423tinselled
towelled1236353t_owelled
trameled11309073trame_led
trammelled1542223trammelled
traveled12349453trave_led
traveller1266603traveller
trowelled1344443trowelled
tunnelled1054583tunnelled
weaseled12175153wease_led

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 Filter1786911486410.406440125.6
2DLD Change Limit148641556.83021763.0
3Display Results55550.0301833.3
 (SQL Overall)178691557.26624592.8
 
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.