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

133 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
admirers113471(None) 
admirer1035521admirer_
admires1038661admire_s
adherers1296922adherers
adjurers1634372adjurers
admirals1144352admirals
admire949932admire__
admired1135702admire_d
admitters1244552admitters
admixes1765962admixe_s
adorers84411732ad_orers
advisers12135002advisers
airers64922312a__irers
armigers1135702armigers
armorers10288972armorers
aspirers1066492aspirers
abiders104011083a_biders
abjurers1733943abjurers
acquirers2043413acquirers
adapters1136103adapters
adders84315703ad__ders
address956103ad_dress
adducers1283443adducers
adherer1137573adherer_
adheres11310163adhere_s
adieus739633ad_i_eus
adjurer1534823adjurer_
adjures1536233adjure_s
adjurors1642863adjurors
admiral1046363admir_al
admiring1236133admiring
admits9411413admi__ts
admittees1243273admittees
admitter1135113admitter_
admixed1833733admixe_d
adopters1136693adopters
adorer74713453ad_orer_
adores74420723ad_ore_s
adorners9196623adorners
adsorbers1243263adsorbers
advices13136933advice_s
advisees12154133advisees
adviser11135783adviser_
advises11138973advise_s
advisors12143903advisors
affirmers1742563affirmers
affixers2143293affixers
aiders74524633a__iders
aimers84621913a__imers
airer54927893a__irer_
aivers94822323a__ivers
aliners74717723a_liners
allurers8286773allurers
almners9399563alm_ners
almoners1068133almoners
alterers82512493alterers
ambeers11428923a_mbeers
ambers104519583a_m_bers
amblers115213563a_mblers
ameers84015573a_m_eers
amercers1256133a_mercers
amices105018013a_mice_s
amides95722663a_mide_s
amies76837693a_mi_e_s
amines84727983a_mine_s
amirs75924923a_mi__rs
ammeters1237693ammeters
ammines11312673ammine_s
amusers94610193a_musers
aquifers2044393aquifers
arbiters1038853arbiters
armers85520273arm__ers
armies85123693armi_e_s
armiger1036253armiger_
armigero1142693armigero
armigeros1242333armigeros
armoires1057623armoire_s
armorer9259913armorer_
armourers1154063armourers
armures9510273armure_s
arrivers11137003arrivers
aspirer967903aspirer_
aspires9612043aspire_s
assurers866313assurers
atomisers11255453atomisers
atomizers20265553atomizers
attires72312953attire_s
augurers9114813augurers
avoiders1254793avoiders
awaiters1146643awaiters
bemires113212833bemire_s
coadmires1444033coadmire_s
daikers124010313_daikers
damagers1237063damagers
dammers123214273dam_mers
damners104112113dam_ners
dampers123915693dam_pers
darers75921873_d_arers
deicers103612733_deicers
demireps1343993demireps
desirers939263desirers
dicers94720743_d_icers
dikers114418793_d_ikers
dimers94321093_d_imers
dimmers123811563_dimmers
diners75525953_d_iners
direr64927073_d_irer_
divers105024963_d_ivers
driers74516733_dri_ers
drivers114412793_drivers
duikers12369383_duikers
expirers1735123expirers
firers94922683__firers
hammerers16216563hammerers
hirers94518063__hirers
limiters10249333limiters
milers84625163__milers
mimers105520183__mimers
miners84126633__miners
mires75640883__mire_s
misers85025703__misers
miters84328783__miters
mixers154513563__mixers
nonadmirers1451893nonadmirers
pumicers1434353pumicers
retirers84311533retirers
smilers94113853_smilers
smirkers14316353_smirkers
smiters93414363_smiters
unmiters1037073unmiters
vomiters1337203vomiters
wirers94617893__wirers
yammerers16214453yammerers

Search took 7 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.1531167915.0
2DLD Change Limit1461621336.37622923.8
3Display Results1331330.0462891.3
 (SQL Overall)1786911336.57527177.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.