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

32 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
uphoarding174272(None) 
hoarding13288642__hoarding
upholding1643372upho_lding
uploading1334662uploa_ding
upsoaring1244512upsoar_ing
boarding123110233__boarding
chording15410153_cho_rding
hoardings14315113__hoardings
hording123517053__ho_rding
pharming16248143_ph_arming
reboarding1445673reboarding
unguarding1343533unguarding
unhanding1437203unh_anding
unhooding1435893unho_oding
unhorsing1336853unho_rsing
unloading1137193unloa_ding
upbearing1435033upbear_ing
upbraiding1643233upbraiding
updarting1334333up_darting
upfolding1642943upfo_lding
upgirding1442373up_girding
upgrading1444903upgra_ding
upheaping1743853uphea_ping
upheaving1843803uphea_ving
uphoard1344573uphoard___
uphoarded1662273uphoard_ed
uphoards1443763uphoard__s
uprearing1238373uprear_ing
upstanding1443713upstanding
upstaring1235963upstar_ing
upstarting1343883upstarting
uptearing1236103uptear_ing

Search took 7 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 Filter1786911406030.406440125.6
2DLD Change Limit140603326.12622951.8
3Display Results32320.000 
 (SQL Overall)178691326.53227356.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.