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

95 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
unhandy144551(None) 
unhand10410381unhand_
unhands1137771unhands
handy125520872__handy
shandy134710032_shandy
uncanny1245112uncanny
unchancy1844702unchancy
unfancy1545202unfancy
unhanded132910182unhanded
unhandily1643732unhandily
unhang1038442unhan_g
unhangs1136202unhangs
unhappy1742802unhappy
unhasty1344282unhasty
unmanly1236992unmanly
bandy114824183__bandy
brandy124712063_brandy
candy115119823__candy
chancy164010863_chancy
chanty145215823_chanty
dandy104416703__dandy
enhance1239693enhance
hand86833713__hand_
hands95327383__hands
hanky155418293__hanky
hardy125622063__hardy
infancy1546173infancy
inland7310313inland_
inlands838783inlands
nancy105214923_n_ancy
nanny84813813_n_anny
nonhardy1544333nonhardy
organdy1254573organdy
pandy115021173__pandy
randy95022083__randy
sandy94221133__sandy
shady125416513_sha_dy
shanny124110093_shanny
shanty124715123_shanty
shindy13449323_shindy
sunland837473sunland_
sunlands936383sunlands
unary8315993un_a_ry
unban72114333unban__
unbanded123010563unbanded
unbans81912623unban_s
unbend9269773unbend_
unbends10236993unbends
unbind93011433unbind_
unbinds10267353unbinds
uncandid1244603uncandid
unchary1537263uncha_ry
undy85015163u___ndy
uneasy9278853unea_sy
unfond10149113unfond_
unfunny1343073unfunny
ungainly1244423ungainly
unhair937333unha_ir
unhairs1036373unhairs
unhandier1344883unhandier
unhanding1437203unhanding
unhandled1445703unhandled
unhanged13258833unhanged
unhat81119263unha__t
unhats91110623unha_ts
unheard1136943unheard_
unhinge11237283unhinge
unholy1238163unh_oly
unhood1039233unhood_
unhoods1137503unhoods
unhumanly17153003unhumanly
unhung1035283unhun_g
unibody1343353unibody
unkend11309223unkend_
unkind113310573unkind_
unkindly1644883unkindly
unlade72714153unla_de
unlaid7311753unlaid_
unlay84613703unla__y
unmade92911063unma_de
unman72715423unman__
unmans82211993unman_s
unpaid939473unpaid_
unready11215943unready
unsaid7411833unsaid_
unsay83212843unsa__y
unsoncy1245513unsoncy
unsonsy1045023unsonsy
untidy1059153un_tidy
untrendy1243483untrendy
unwary1239823unwa_ry
unwind102610543unwind_
unwinds11286733unwinds
upland938863upland_
uplands1036943uplands

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.406440125.6
2DLD Change Limit134027956.67320085.0
3Display Results95950.0303166.7
 (SQL Overall)178691957.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.