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

102 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
ignifies127756(None) 
dignifies1446361dignifies
ignified1386211ignified
lignifies1346261lignifies
signifies1347061signifies
dignified1545572dignified
dignities1149592dignities
ignites81310582igni_tes
lignified1445062lignified
magnifies1547282magnifies
minifies13312902minifies
nigrifies1346362nigrifies
significs1543682significs
signified1446042signified
signifieds1543072signifieds
signifier1345712signifier
signifiers1444182signifiers
uglifies1246382uglifies
unifies102714712_unifies
vinifies1439872vinifies
aerifies111313393aerifies
agnizes17328843agni_zes
basifies13310493basifies
canities101519263canities
carnifies1439893carnifies
citifies13310683citifies
codifies1439643codifies
cornifies1439003cornifies
damnifies1545543damnifies
dandifies1476893dandifies
deifies113317453_deifies
densifies1347993densifies
edifies113012283_edifies
fancifies1767083fancifies
gasifies1238693gasifies
griffes14367923_griffes
identifies1445803identifies
ignatias944913ignatias
ignify1334513ignif__y
ignifying1744313ignifying
ignite71410583igni_te_
ignited9137623igni_ted
igniter8147673igni_ter
igniters9126233igniters
igniting1037363igniting
ignition946533ignition
ignitions1045803ignitions
ignitors9135513ignitors
ignominies1343333ignominies
ignores8269003ign_ores
inanities9312443inanities
indies73822783i_n_dies
infixes17238133i_nfixes
ionises72916433ioni_ses
ionizes162813343ioni_zes
knifes136210213_knif_es
lenities8315943lenities
lignites9129613ligni_tes
liquifies2144883liquifies
lithifies1545503lithifies
magnified1645763magnified
magnifier1545273magnifier
magnifiers1643813magnifiers
micrifies16118673micrifies
minified1439653minified
modifies1439163modifies
nazifies2036063nazifies
nidifies1238233nidifies
nifties102612503__nifties
nigrified1445333nigrified
nitrifies12107923nitrifies
nixies135313873__nixies
notifies11310423notifies
ossifies1177563ossifies
pacifies15311223pacifies
purifies13311923purifies
ramifies13310503ramifies
rarifies11311933rarifies
ratifies11313513ratifies
reifies104218283_reifies
reunifies1247583reunifies
rigidifies1543593rigidifies
salifies11314793salifies
sanities81219773sanities
signiories1144303signiories
signories10107853signories
typifies1644963typifies
uglified1345293uglified
uglifier1244503uglifier
uglifiers1343093uglifiers
unified112413573_unified
unifier102211863_unifier
unifiers11237173_unifiers
unities72520153_unities
vanities111414493vanities
verifies141313483verifies
vilifies1439593vilifies
vinified1537543vinified
vitrifies1547223vitrifies
vivifies1747023vivifies
zincifies2344953zincifies
zinkifies2543503zinkifies

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621027.42019698.4
3Display Results1021020.0502040.0
 (SQL Overall)1786911027.89322639.2
 
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.