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

116 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
nazifies203606(None) 
nazified2144991nazified
basifies13310492basifies
denazifies2343292denazifies
gasifies1238692gasifies
nidifies1238232nidifies
notifies11310422notifies
pacifies15311222pacifies
ramifies13310502ramifies
rarifies11311932rarifies
ratifies11313512ratifies
salifies11314792salifies
aerifies111313393aerifies
alibies9313323_alibies
amities9317383_amities
analities9715873analities
azides165113803_azi_des
azines155517073_azi_nes
baffies153612943ba_ffies
bailies94120203ba_ilies
basified1437823basified
basifier1337313basifier
basifiers1445203basifiers
beatifies1459283beatifies
calcifies1638923calcifies
canities101519253canities
carnifies1439893carnifies
casefies1339213casefies
cavities131412613cavities
caziques28193773caziques
citifies13310683citifies
clarifies1448633clarifies
coalifies1439113coalifies
codifies1439643codifies
dailies84219263da_ilies
dairies84217733da_iries
daisies84217093da_isies
damnifies1545543damnifies
dandifies1476893dandifies
deifies113317453_deifies
denazified2443063denazified
edifies113012283_edifies
fairies103516043fa_iries
falsifies1545983falsifies
families1339443families
fancifies1767083fancifies
gasified1336533gasified
gasifier1236273gasifier
gasifiers1344523gasifiers
gratifies1347993gratifies
ignifies1277563ignifies
inanities9312443inanities
laities7320343la_ities
laxities1539093laxities
lazies154418783laz__ies
magnifies1547283magnifies
minifies13312903minifies
modifies1439163modifies
naiades838213na_iades
naifs87617423na_if__s
naives94914223na_i_ves
nancies93516843na_ncies
nancified1565543nancified
nannies73015203na_nnies
naperies10313903naperies
nappies114613393na_ppies
nasties73520493na_sties
natives10310823nati_ves
navies95218623na__vies
navvies1335323na_vvies
nazify2134233nazif__y
nazifying2543473nazifying
nazis145216083naz__i_s
nidified1346763nidified
nifties102612503n__ifties
nigrifies1346363nigrifies
nitrifies12107923nitrifies
nixies135313873n__ixies
notified1238363notified
notifier1137423notifier
notifiers1245023notifiers
nudities939683nudities
nullifies1245803nullifies
opacifies1645463opacifies
ossifies1177563ossifies
pacified1638363pacified
pacifier1557503pacifier
pacifiers1645463pacifiers
parities10522973parities
purifies13311923purifies
qualifies2147503qualifies
ramified1438043ramified
ramilies10311833ramilies
rarefies1138993rarefies
rarified1239053rarified
rarities8316333rarities
ratified12310503ratified
ratifier1139673ratifier
ratifiers1236453ratifiers
reifies104218283_reifies
salified12310363salified
salsifies1247253salsifies
sanities81219763sanities
satisfies1245323satisfies
scarifies1439603scarifies
tackifies1845783tackifies
taffies133012693ta_ffies
typifies1644963typifies
uglifies1246383uglifies
unifies102714713_unifies
vanities111414493vanities
verifies141313483verifies
vilifies1439593vilifies
vinifies1439873vinifies
vivifies1747023vivifies
waffies163611443wa_ffies

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 Filter1786911461620.1701051123.5
2DLD Change Limit1461621168.30017609.9
3Display Results1161160.0462521.7
 (SQL Overall)1786911168.51620983.0
 
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.