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

84 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
micrify174469(None) 
metrify1535622metrify
midriff1645512midriff
minify1439252mi_nify
nigrify1444132nigrify
nitrify1335792nitrify
vitrify1645002vitrify
acidify1645243acidify
aerify122810113_aerify
airily93014823ai_rily
citify1437443ci_tify
clarify1536093clarify
dicliny1337673dicliny
dignify1543893dignify
fierily1339023fierily
glorify1444583glorify
horrify1635023horrify
icily101211693_ic_ily
ickily1535753_ickily
ignify1334513_ignify
lignify1443793lignify
liquify2244033liquify
lithify1644763lithify
magnify1634533magnify
merrily1238633merrily
miching152911803miching
mickey174211853mic_key
micra96214973micr__a
micrified17126793micrified
micrifies16118673micrifies
micrifying2144813micrifying
micro94715993micr__o
microbe1338663microbe
microhm1646123microhm
micron103714283micr_on
microns113814783microns
micros104115363micr_os
micrurgy1641593micrurgy
midlife13248303midlife
midrib1138243midri_b
midribs1235513midribs
midriffs1742533midriffs
midwife16225523midwife
miffy163910203mi__ffy
milkily16216553milkily
minority1347933minority
miri66730373mi_ri__
mirier83918363mi_rier
mirin75023153mi_ri_n
miring93723803mi_ring
mirins83918903mi_rins
mirkily16266403mirkily
mirky146315523mi_r_ky
miry96326753mi_r__y
misrely12319613misrely
mistily122612343mistily
mitring103514143mitring
modify1537173m_odify
mollify1555503mollify
mortify1536223mortify
muckily18277743muckily
mummify1643333mummify
mystify1843563mystify
nidify1336763ni_dify
pacify1667473pac_ify
petrify1536573petrify
picric12309923picri_c
picrite111911313picrite
purify14399153_purify
rarify123210063_rarify
rectify1536453rectify
scarify1537443scarify
scorify1535203scorify
signify1444853signify
tackify1934493tackify
terrify1336353terrify
torrify1335013torrify
verify153110163_verify
vilify1536773vi_lify
vinify1536923vi_nify
vivify1834703vi_vify
wirily123310783wi_rily
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 Filter1786911340270.420425454.8
2DLD Change Limit134027846.81319672.2
3Display Results84840.0332545.5
 (SQL Overall)178691847.26624592.8
 
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.