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

134 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
adjurer153482(None) 
abjurer1634751abjurer
adjure1435841adjure_
adjured1634881adjured
adjurers1634371adjurers
adjures1536231adjures
adjuror1542891adjuror
abjure1536742abjure_
abjured1735082abjured
abjurers1733942abjurers
abjures1636522abjures
adducer1184162adducer
adherer1137572adherer
adjurors1642862adjurors
adjuster1644352adjuster
admirer1035522admirer
adorer74713452ad_orer
allurer7348432allurer
assurer767792assurer
augurer8136342augurer
dourer74215272_dourer
injurer14318472injurer
absurder11134363absurder
abuser85413683a_buser
accuser11347933accuser
acquirer1944093acquirer
acuter84412863a_cuter
adapter1036173adapter
adder75419593ad__der
adduce1076453adduce_
adduced1274353adduced
adducers1283443adducers
adduces1185763adduces
adepter1036113adepter
adhere10310333adhere_
adhered1239233adhered
adherers1296923adherers
adheres11310163adheres
adjourn1563433adjour_n
adjourned1842063adjourned
adjourns1662863adjourns
adjudge1742613adjudge
adjudged1941913adjudged
adjudges1842333adjudges
adjunct1753583adjunct
adjuring1735103adjuring
adjust1447183adju_st
adjusted1743613adjusted
adjusters1744163adjusters
adjustor1643123adjustor
adjusts1544513adjusts
admire949933admire_
admired1135703admired
admirers1134713admirers
admires1038663admires
adopter1036763adopter
adore65723673ad_ore_
adored84714243ad_ored
adorers84411733ad_orers
adores74420723ad_ores
adorner8246983adorner
adsorber1143503adsorber
adviser11135783adviser
airer54927893a__irer
allure63012943allure_
allured8299173allured
allurers8286773allurers
allures72913113allures
alterer72713993alterer
amuser84712623a_muser
arguer74510543argu_er
armorer9259913armorer
armourer1054883armourer
armure8710133armure_
armures9510273armures
arouser74514423arouser
aspirer967903aspirer
assumer965363assumer
assure6610773assure_
assured858373assured
assurers866313assurers
assures7611403assures
assuror754203assuror
auger64922473a__uger
augured987193augured
augurers9114813augurers
aurar54420253a__urar
aurei54821863a__urei
aures55137093a__ures
azure14911483a_zure_
azures15510183a_zures
capturer1246093capturer
conjurer17117683conjurer
curer75030753__curer
darer65230793_d_arer
dauber94112013_dauber
dearer74822803_dearer
demurer1037873demurer
direr64927073_d_irer
douser75621633_douser
duper85519003_d_uper
dure56341813_d_ure_
dured75025403_d_ured
dures65635923_d_ures
durr55624353_d_ur_r
endurer83210363endurer
ensurer73011903ensurer
favourer1443823favourer
figurer11215863figurer
impurer1136483impurer
injure133410863injure_
injured15339063injured
injurers15286123injurers
injures143111173injures
insurer73312803insurer
jurel124516333__jurel
juror1239563__juror
labourer1045753labourer
lurer54625313__lurer
manurer938583manurer
maturer938973maturer
pasturer1037523pasturer
perjurer17285903perjurer
pourer84516043_pourer
purer75127903__purer
savourer1134473savourer
scourer93910433scourer
securer958253securer
sourer63620213_sourer
surer54833103__surer
tabourer1035743tabourer
tourer64115073_tourer
usurer638103_usurer
vapourer1344263vapourer

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 Filter1786911340270.390458182.1
2DLD Change Limit1340271346.14321817.8
3Display Results1341340.0433116.3
 (SQL Overall)1786911346.57627173.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.