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

245 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
deifiers1234899(None) 
defiers113913991de_fiers
deifier113013121deifier_
deifies113317451deifie_s
edifiers12336671edifiers
reifiers11309841reifiers
decriers11299732decriers
defers105116942de_f_ers
defier105118652de_fier_
defies104624052de_fie_s
defilers12439472defilers
definers124211192definers
deicers103612732dei_cers
deified123112412deifie_d
deities82621922deitie_s
deniers84515182de_niers
differs14339972d_iffers
drifters12417912drifters
edifier11309262edifier_
edifies113012282edifie_s
heifers1337932heif_ers
reifier103414522reifier_
reifies104218282reifie_s
unifiers11237172unifiers
verifiers15166062verifiers
acetifiers1543403acetifiers
aerifies111313393aerifie_s
basifiers1445203basifiers
beefier12329093beefier_
beliers94617383be_liers
ceilers93912533cei_lers
certifiers1545153certifiers
codifiers1555343codifiers
daffier1457833daffier_
daikers124010313dai_kers
dailies84219263dailie_s
dairies84217733dairie_s
daisies84217093daisie_s
dalliers93610623dalliers
deafens11317253deaf_ens
deafer104114813deaf_er_
deafness1236213deafness
deairs74013783de_ai_rs
dealers84118613de_alers
dearies83526273dearie_s
debasers11377903debasers
debaters113511923debaters
deboners11268113deboners
debriefs1433533debriefs
decayers14307963decayers
deceivers1535723deceivers
deciders123510753deciders
deciliters1345173deciliters
deciphers1744393deciphers
deckers144413833de_ckers
decliners12358613decliners
decoders122810413decoders
decoyers14287713decoyers
decreers11277623decreers
decrier102713563decrier_
decries103319813decrie_s
deedier93011593deedier_
deers64930523de___ers
defacers14237993defacers
defamers14258523defamers
defer94619753de_f_er_
deffer134411303de_ffer_
defied115016383de_fie_d
defiler113911883defiler_
defiles114016843de_files
definer114413773definer_
defines114118683de_fines
definiens1345303definiens
defis96717503de_fi__s
defleas1147223de_fleas
defter104215923de_fter_
defuels11296983de_fuels
defusers12487363defusers
deicer94114413dei_cer_
deices94119373dei_ce_s
deicides1249303deicides
deific1237313deifi__c
deifical1445543deifical
deiform1336703deif_orm
deionizers2053973deionizers
deixis1437243deixi__s
deixises1635693deixises
delayers12268663delayers
delimiters1345103delimiters
delivers123310753delivers
dellies83622213dellie_s
deluders10156433deluders
delvers113411993de_lvers
demies94825803de_mie_s
demisters1249203demisters
denier74420693de_nier_
denies74729643de_nie_s
densifies1347993densifie_s
denuders10165873denuders
depicters1435823depicters
deposers11359243deposers
deprivers1545213deprivers
derbies103016053derbie_s
deriders102411853deriders
deringers1137183deringers
derivers123811363derivers
dernier83011943dernier_
derriere936043derriere
derrieres1044813derrieres
derries83124623derrie_s
descriers1245693descriers
designers1136003designers
desilvers13306083desilvers
desirers939263desirers
desires81316133de_sires
despisers1245153despisers
destriers1038143destriers
detailers10257253detailers
detainers10269103detainers
deters74724683de__ters
detickers1634423detickers
devisers12339863devisers
devoirs1175783devoi_rs
dewaters122910723dewaters
dewier104013463de_wier_
dexies145018343de_xie_s
dialers83614303d_ialers
diapers104713913d_iapers
dibbers124013173d_ibbers
dicers94720743d_i_cers
dicier94416233d_icier_
dickers144117663d_ickers
didies84621833d_idie_s
diesters92513603diesters
dieters83216433d_ieters
diethers1257453diethers
differ133910843d_iffer_
diggers104413393d_iggers
dikers114418793d_i_kers
dimers94321093d_i_mers
dimmers123811563d_immers
diners75525953d_i_ners
dingers94321383d_ingers
dinners83915443d_inners
dippers123615183d_ippers
dithers114016153d_ithers
divers105024963d_i_vers
dividers13257213d_ividers
diviners12308353d_iviners
doffers14359853d_offers
doilies84017363doilie_s
dossiers9318043dossiers
drafters12338533drafters
driers74516733d__riers
drifter11348703drifter_
driftier1275123driftier_
drillers9429723drillers
drinkers13277823drinkers
drippers13327943drippers
drivers114412793dri_vers
duffers143410093d_uffers
duikers12369383dui_kers
edifices1454863edifices
edified12339713edifie_d
eiders74321363_ei_ders
enviers1036993_enviers
feigners1235483feigners
feoffers1333133feoffers
fifers125414923_fif_ers
gasifiers1344523gasifiers
grifters12389233grifters
hefters134312003he_fters
heifer1238203heif_er_
heinies102514543heinie_s
heisters113413133heisters
identifiers1552863identifiers
kefirs13396653ke_fi_rs
keisters123212043keisters
knifers14537083knif_ers
leafier10329833leafier_
leisters83312823leisters
leviers103510343le_viers
lifers95617843_lif_ers
lifters104313783_lifters
liviers104211073_liviers
meinies92516073meinie_s
meisters103313843meisters
metiers93312843me_tiers
modifiers1584483modifiers
niffers13287363_niffers
notifiers1245023notifiers
ossifiers1274883ossifiers
pacifiers1645473pacifiers
petrifiers1544673petrifiers
pitiers93812653_pitiers
purifiers1435883purifiers
ratifiers1236453ratifiers
rectifiers1545173rectifiers
reefers103312593reef_ers
reefier102912553reefier_
refers93921083re_f_ers
refiners114713313refiners
refires104820313re_fires
reified112913783reifie_d
reinters82614773reinters
reivers105117083rei_vers
reliers75519213re_liers
rentiers83311763rentiers
reoffers1434693reoffers
repliers103710163repliers
ribiers9319753_ribiers
riflers103512203_riflers
seiners74219273sei_ners
seisers73816393sei_sers
seizers164112503sei_zers
shifters14319863shifters
sifters103714793_sifters
sniffers14257123sniffers
snifters11318613snifters
specifiers1743803specifiers
stiflers11238833stiflers
swifters14277483swifters
telfers10299083telf_ers
terriers84210823terriers
terrifiers13144573terrifiers
testifiers13124503testifiers
tidiers8389773_tidiers
triflers113110223triflers
typifiers1742303typifiers
uglifiers1343093uglifiers
unifier102211863unifier_
unifies102714713unifie_s
veilers103911823vei_lers
veiners104112523vei_ners
veinier10269583veinier_
verifier14159203verifier_
verifies141313483verifie_s
verniers11227843verniers
versifiers16154143versifiers
vilifiers1544563vilifiers
vivifiers1843673vivifiers
viziers19336203_viziers
weighers15135673weighers
weiners103913063wei_ners
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.466383457.1
2DLD Change Limit1461622457.12620511.1
3Display Results2452450.0932634.4
 (SQL Overall)1786912457.68523251.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.