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 “wraths” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

68 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
wraths12381008(None) 
wraiths1355031wraiths
wrath115715871wrath_
wrathy15377851wrathy
wreaths13338371wreaths
baths105922922_baths
brachs134415752brachs
brats75336012brat_s
breaths124411182breaths
briths115113862briths
broths115013922broths
crates85736062crates
crwths1433432crwths
deaths105914442deaths
drats66628372drat_s
earths95014592earths
frats86829672frat_s
friths124313582friths
froths125411442froths
garths104111502garths
graphs124510152graphs
grates75429892grates
gratis74819242gratis
griths105211652griths
heaths126316382heaths
laths86022402_laths
maths105624022_maths
oaths86117312_oaths
orates64328612orates
paths105521382_paths
prates84633162prates
prats76333392prat_s
rates55352012_rates
rath76037662_rath_
rathe85821922_rathe
ratos55528762_ratos
rats46260372_rat_s
ruths85714642_ruths
snaths95112912snaths
straths102711722straths
swarths13537322swarths
swaths125312642swaths
troths95414152troths
truths9449502truths
urates65027762urates
warmths1583782warmths
warpaths1643972warpaths
warts814840402wart_s
wats77555882w_at_s
watts86923092w_atts
wealths13365812wealths
whats117718992what_s
widths1335122widths
worths127812892worths
wracks154711112wracks
wraith1258602wraith_
wrangs104611912wrangs
wraps105617152wra_ps
wrathed14298522wrathed
wreath124111192wreath_
wreathe13339052wreathe
wreathes14299892wreathes
wreathy16326062wreathy
writes94420332writes
writhe125310702writhe
writhes134811702writhes
writs86624382writ_s
wroth116815882wroth_

Search took 3 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 Filter178691825510.356501941.0
2DLD Change Limit82551682.58031996.5
3Display Results68680.0302266.7
 (SQL Overall)178691682.96660246.5
 
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.