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

49 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
tomalley134328(None) 
tomalleys1441671tomalleys
tomatoey1344102tomatoey
tonally10311372tonall_y
totalled935842totalled
totally1039892totall_y
alley85721673___alley
atonally1148633atonall_y
focally15188553focall_y
formally1638243formall_y
galley104215453__galley
locally12179723locall_y
loyally13126843loyall_y
malled94626113__malled
mallee84525593__mallee
mallei84414633__mallei
mallet84433053__mallet
modally1338403modall_y
morally12411493morall_y
mulley114013453__mulley
nodally1137913nodall_y
normally1347883normall_y
orally93113593_orall_y
ovally12278443_ovall_y
royally13157733royall_y
smaller93410333_smaller
taller63721963t__aller
tally84526863t__all_y
tamable11312853tamable_
tamale83717403tama_le_
tamales93216153tama_les
thralled1245803thralled
tidally1137933tidall_y
tolled73819033to__lled
toller63819443to__ller
tomatoes1038613tomatoes
tonality1139793tonality
totable92313363totable_
totaled839693tota_led
totality1139373totality
towable121910113towable_
towelled1236353towelled
trawley13317303t_rawley
trolley10328753t_rolley
valley124311603__valley
vocally15188343vocall_y
volley12419743vo__lley
womanly1535853womanl_y
zonally1938003zonall_y

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 Limit146162497.78318779.6
3Display Results49490.0301633.3
 (SQL Overall)178691498.24921662.1
 
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.