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

181 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
nidify133676(None) 
acidify1645242acidify
citify1437442citify
codify1537162codify
edify12308562_edify
minify1439252minify
modify1537172modify
nazify2134232nazify
nidi56524392nidi__
niding83217972niding
nigrify1444132nigrify
nitrify1335792nitrify
notify1236942notify
nudity1037992nudity
tidily102811392tidily
vilify1536772vilify
vinify1536922vinify
vivify1834702vivify
acidity1338593acidity
aerify122810113aerify
aiding84423613aiding
airily93014823airily
anility10312723anility
aridity11510113aridity
avidity1436483avidity
basify1437513basify
biddy124612693bid_dy
bidi78226573bidi__
biding104720793biding
bidis86721143bidi_s
biffy164711133bi_ffy
bodily12310993bodily
dandify15245673dandify
defy114921263__defy
deify124112763_deify
diddly12389573diddly
didie74120563didi_e
didies84621833didies
didy99121503__didy
dif76846903__dif_
diff116228843__diff
difs86027323__difs
dignify1543893dignify
dimity12310473dimity
fiddly14328483fiddly
fixity19427803fixity
gasify1336333gasify
giddily1335073giddily
giddy115810203gid_dy
hiding114319333hiding
humidify2042723humidify
icily101211693_icily
idiocy1273463_idiocy
idiom899963_idiom
idiot6718863_idiot
idly85617323_id_ly
iffy135312283_i_ffy
ignify1334513ignify
indict93115573indict
indie63721473indi_e
indies73822783indies
indign8308473indign
indigo8388023indigo
indite73520323indite
indium939503indium
jiffy21458313ji_ffy
jiminy1836273jiminy
kiddy144910273kid_dy
kidney1434753kidney
lapidify1742803lapidify
lignify1443793lignify
liquify2244033liquify
lithify1644763lithify
micrify1744693micrify
midday13327503midday
middy124812593mid_dy
midi75628473midi__
midis85923413midi_s
midlife13248303midlife
midriff1645513midriff
midway15327153midway
midwife16225523midwife
miffy163910203mi_ffy
nadir61012973nadi_r
nadirs7109003nadirs
naif76839023n_aif_
naifs87617423n_aifs
neddy10479873ned_dy
needily1166323needily
neif75429493n_eif_
neifs85613043n_eifs
nicely1139493nicely
nicety1138433nicety
nidal65217103nid_al
nidate7313783nidate
nide55535783nid__e
nided75920873nid_ed
nides65229133nid_es
nidget83715633nidget
nidified1346763nidified
nidifies1238233nidifies
nidifying1744213nidifying
nidus65913573nid_us
niftily1335753niftily
nifty115211633ni_fty
niggly11418913niggly
nighty135611273nighty
nihil8410283nihi_l
nihils937573nihils
nimbly13388773nimbly
nimiety1244633nimiety
ninety9510963ninety
ninny84514933ni_nny
nippily1444713nippily
nippy124911113ni_ppy
nisi45823243nisi__
nitery94412173nitery
nitid61817833niti_d
nitty85418313ni_tty
nixie125114943nixi_e
nixies135313873nixies
nixing143311493nixing
nixy145714513n__ixy
noddy105411203nod_dy
nodi56626743nodi__
noily86120993n_oily
noisily1038403noisily
noisy86813363n_oisy
nosily93712683nosily
nudely10299033nudely
nudie65118673nudi_e
nudies75217093nudies
nudism9357913nudism
nudist73813323nudist
nullify1334713nullify
oddity1135243oddity
oidia6314953oidi_a
oidium959813oidium
oilily93111723oilily
ossify1244973ossify
pacify1667473pacify
piddly13319143piddly
purify14399153purify
ramify14268753ramify
rarify123210063rarify
ratify122610043ratify
redefy13388763redefy
reedify1465763reedify
reify114814973_reify
ridgy104110643rid_gy
riding84325963riding
ridley10169543ridley
rigidify1642463rigidify
salify12311373salify
siding83822133siding
signify1444853signify
snidely1136803snidely
sniffy15337193sni_ffy
solidify1544193solidify
tiddly11308783tiddly
tidied83613273tidied
tidier73515113tidier
tidies74721833tidies
tiding83520093tiding
tidy86822413tid__y
tinily94014433tinily
typify1734523typify
uglify1333913uglify
unify113611113_unify
untidily1245873untidily
verify153110163verify
viduity1445343viduity
vitrify1645003vitrify
widdy136112183wid_dy
widely133311033widely
widish13419363widish
wilily123310763wilily
windily1437943windily
wirily123310783wirily
zincify2443913zincify
zinkify2643123zinkify

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127161817.25015547.0
3Display Results1811810.0632873.0
 (SQL Overall)1786911817.45323975.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.