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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

112 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
unmanly123699(None) 
humanly1545682humanly
manly105022952__manly
uncanny1245112uncanny
unfancy1545202unfancy
ungainly1244422ungainly
unhandy1445512unhandy
unhumanly17153002unhumanly
unman72715422unman__
unmans82211992unman_s
unwomanly1752682unwomanly
womanly1535852womanly
anally9513503an_ally
animally1368643animally
anomaly1238843anoma_ly
cleanly1236323cleanly
gnarly104610383gn_arly
gunman9299453gunman__
humanely1643813humanely
inanely1037943in_anely
infancy1546173infancy
inhumanly17163673inhumanly
insanely1146123insanely
leanly93811503_leanly
madly115218133__madly
mainly11411493__mainly
mangy115021253__mangy
many95731863__man_y
marly106925613__marly
meanly115412043_meanly
mundanely1542983mundanely
namely113711323_namely
nancy105214923_n_ancy
nanny84813813_n_anny
nearly94813733_nearly
neatly93812483_neatly
numbly134410663num_bly
seamanly1345403seamanly
snarly93815003sn_arly
tunably12218293tun_ably
tuneably1346093tuneably
unable83819223un_able
unaptly1244793unaptly
unary8315993un_a_ry
unbale83616403unba_le
unban72114333unban__
unbans81912623unban_s
uncannily1443453uncannily
unchancy1844703unchancy
uncially1339073uncially
uncleanly1444183uncleanly
unduly1037823un_duly
uneasily1146453uneasily
uneasy9278853unea_sy
unevenly1444613unevenly
unfairly1443563unfairly
unfitly1335573unfitly
unfunny1343073unfunny
ungently1256953ungently
ungodly1244473ungodly
unhand10410383unhan_d
unhandily1643733unhandily
unhands1137773unhands
unhang1038443unhan_g
unhangs1136203unhangs
unhappy1742803unhappy
unhasty1344283unhasty
unholy1238163un_holy
unkindly1644883unkindly
unkingly1637253unkingly
unlay84613703unla__y
unmacho1443923unmacho
unmade92911063unma_de
unmailed11229763unmailed
unmake122811213unma_ke
unmaker13279513unmaker
unmakes132810793unmakes
unmanful1343433unmanful
unmanlier1144243unmanlier
unmanned11268603unmanned
unmannerly1552073unmannerly
unmask1265903unma_sk
unmasks1344553unmasks
unmated103317023unmated
unmeant9510903unmean_t
unmeetly1344073unmeetly
unmerry1245023unmerry
unmined102612953unmined
unmingle1145913unmingle
unmold9148313unm_old
unmorally1445703unmorally
unnail6410583unnail_
unnails738223unnails
unreally1148233unreally
unruly938083un_ruly
unsafely1454413unsafely
unsaintly1244993unsaintly
unsay83212843unsa__y
unsoncy1245513unsoncy
unsonsy1045023unsonsy
unstably1339493unstably
untangle966323untangle
untruly1046293untruly
unwarily1446363unwarily
unwary1239823unwa_ry
uranyl936293u_ranyl
urbanely1343693urbanely
usably11288983u_sably
useably1287393useably
usually1066063usually
wanly115118023__wanly
yeomanly1643213yeomanly

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 Filter1786911340270.423422437.4
2DLD Change Limit1340271128.47015823.7
3Display Results1121120.0462434.8
 (SQL Overall)1786911128.93919990.0
 
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.