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

132 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
unifiers1123717(None) 
unifier102211861unifier_
unifies102714711unifie_s
deifiers12348992deifiers
edifiers12336672edifiers
knifers14537082knif_ers
niffers13287362_niffers
purifiers1435872purifiers
reifiers11309842reifiers
sniffers14257122sniffers
snifters11318612snifters
uglifiers1343092uglifiers
unified112413572unifie_d
uniters73814172uni_ters
unities72520152unitie_s
unitizers1843922unitizers
basifiers1445203basifiers
codifiers1555343codifiers
conifers133611703conif_ers
crucifiers1743073crucifiers
defiers113913993_defiers
deifier113013123deifier_
deifies113317453deifie_s
differs14339973_differs
drifters12417913drifters
edifier11309263edifier_
edifies113012283edifie_s
enviers1036993en_viers
fifers125414923_fif_ers
fusiliers1243713fusiliers
gasifiers1344523gasifiers
grifters12389233grifters
gunfires1235063gun_fires
heifers1337933heif_ers
ignifies1277563ignifie_s
infers93615443in_f_ers
inliers73110743in_liers
junipers1733933juni_pers
justifiers2043083justifiers
knickers13306723knickers
knifer13598563knif_er_
knifes136210213knif_e_s
knitters12336623knitters
lifers95617843_lif_ers
lifters104313783_lifters
liviers104211073_liviers
lucifers1334163lucif_ers
magnifiers1643813magnifiers
minifies13312903minifie_s
modifiers1584483modifiers
nickers134415093_nickers
niffer12378443_niffer_
niftier10328713_niftier_
nifties102612503_niftie_s
niggers93111323_niggers
nippers113012623_nippers
niters64624213_ni_ters
nixies135313873_nixie_s
notifiers1245023notifiers
nullifiers1343153nullifiers
ossifiers1274883ossifiers
pacifiers1645463pacifiers
pitiers93812653_pitiers
punishers1434973punishers
purifier1338573purifier_
purifies13311923purifie_s
qualifiers2243333qualifiers
quantifiers2352503quantifiers
ratifiers1236453ratifiers
reifier103414523reifier_
reifies104218283reifie_s
reunifies1247583reunifie_s
ribiers9319753_ribiers
riflers103512193_riflers
shifters14319863shifters
sifters103714793_sifters
signifiers1444183signifiers
snickers143010963snickers
sniffer13318903sniffer_
sniffier14356643sniffier_
snifflers15275053snifflers
snifter10349623snifter_
sniggers10317093sniggers
snipers93311773sni_pers
snippers12299723snippers
snuffers14326923snuffers
stiflers11238833stiflers
swifters14277483swifters
tidiers8389773_tidiers
triflers113110213triflers
typifiers1742303typifiers
uglifier1244503uglifier_
uglifies1246383uglifie_s
uncovers1336573uncovers
undies73821963un_die_s
undoers82910583un_doers
unfired112212453un_fired
unfits93910293un_fi_ts
unfixes17238113un_fixes
unfrees1048643un_frees
unhairers12183273unhairers
unhairs1036373unhai_rs
unifaces1346393unifaces
unific1137463unifi__c
unifilar1143263unifilar
uniform1247053unif_orm
uniforms1355043uniforms
unionizers1943013unionizers
uniquer1675783uniquer_
uniques1667443unique_s
uniter64619143uni_ter_
unites65024853uni_te_s
unitizer1746203unitizer_
unitizes1739133unitizes
universe1145253uni_verse
unlimbers1342583unlimbers
unmakers14256653unmakers
unmiters1037073unmiters
unquiets1744313unquiets
untidier946783untidier_
untidies939813untidie_s
unties64326923un_tie_s
unwinders1343943unwinders
uplifters1463283uplifters
utilisers953553utilisers
utilizers1854553utilizers
verifiers15166063verifiers
vilifiers1544563vilifiers
vinifies1439873vinifie_s
vivifiers1843673vivifiers
viziers19336203_viziers
whiffers2064493whiffers

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 Limit1461621326.87621256.8
3Display Results1321320.0462869.6
 (SQL Overall)1786911327.34524328.3
 
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.