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

64 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
unhappy174280(None) 
happy155813532__happy
nappy126312332_n_appy
snappy1366102sn_appy
unhandy1445512unhandy
unhappily1982082unhappily
unhasty1344282unhasty
champy18509613_champy
chippy18437613_chippy
choppy18376293_choppy
crappy15446803_crappy
enthalpy1642563enthalpy
flappy1654483_flappy
gappy136212033__gappy
haply135915063__haply
harpy136418213__harpy
hippy155112793__hippy
hoppy154912353__hoppy
nappa98511863_n_appa
nappe96114993_n_appe
nippy124911113_n_ippy
pappy114713803__pappy
sappy125413473__sappy
schappe1635263schappe
scrappy16234473scrappy
sharpy145211033_sharpy
shnapps1463343shnapps
snippy1374843sn_ippy
strappy14205263strappy
unapt710421593un_a_pt
unaptly1244793un_aptly
unary8315993un_a_ry
uncanny1245113uncanny
uncap9312283unca_p_
uncapped1556693uncapped
uncaps1039813unca_ps
unchancy1844703unchancy
unchary1537263uncha_ry
uneasy9278853unea_sy
unfancy1545203unfancy
unhair937333unha_ir
unhairs1036373unhairs
unhand10410383unha_nd
unhands1137773unhands
unhang1038443unha_ng
unhangs1136203unhangs
unhappier1642393unhappier
unhat81119263unha__t
unhats91110623unha_ts
unhip10178823unh_ip_
unholy1238163unh_oly
unhoped13249353unhoped
unlay84613703unla__y
unmanly1236993unmanly
unmapped1535173unmapped
unsay83212843unsa__y
unshaped14148443unshaped
unshapely1742823unshapely
unshapen13155443unshapen
unsharp1235543unsharp_
untapped1376613untapped
unwary1239823unwa_ry
whippy19385843_whippy
zappy21548943__zappy

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 Filter1786911340270.403443402.0
2DLD Change Limit134027646.69020033.9
3Display Results64640.0164000.0
 (SQL Overall)178691647.10925135.9
 
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.