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

109 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
admitted123476(None) 
admittee1145131admittee
admitter1135111admitter
addicted1345072addicted
admired1135702admi_red
admittedly1751662admittedly
admittees1243272admittees
admitters1244552admitters
admixed1833732admi_xed
coadmitted16112382coadmitted
demitted12288772demitted
emitted103010852_emitted
omitted10347892_omitted
readmitted1443462readmitted
remitted113312072remitted
unadmitted1443022unadmitted
abetted1058323a_betted
abutted1056983a_butted
acquitted2143503acquitted
adapted1135843ad_apted
adducted1343913adducted
adhibited1642473adhibited
adjusted1743613adjusted
admire949933admi_re_
admirer1035523admi_rer
admires1038663admi_res
admit8319493admi_t__
admits9411413admi_t_s
admitting1345033admitting
admixes1765963admi_xes
admixt1637333admixt__
adopted1136253ad_opted
adulated1039753adulated
advected1534533advected
adverted1336103adverted
advised12136043advi_sed
agisted938203a_gisted
agitated1038413a_gitated
aglitter935093aglitter
airted74214503a__irted
allotted986873allotted
amities9317383a_mities
animated111612373animated
anointed938343anointed
arointed939003arointed
assisted936233assisted
attritted1044493attritted
atwitter1143673atwitter
audited939033audi_ted
aviated11310263a_viated
awaited1146963awai_ted
babbitted1342953babbitted
befitted14305723befitted
bemisted1368383bemisted
bitted94418483__bitted
committed1645723committed
dieted83115493_d_ieted
dimwitted1642293dimwitted
dinted84419843_d_inted
dittoed936733_d_ittoed
doited85016633_doi_ted
dotted84717523_d_otted
dratted9358593_dratted
drifted12367953_drifted
duetted937023_duetted
edited83913673ed_i_ted
emitter93211083_emitter
fitted104716663__fitted
flitted114011643_flitted
fritted113611333_fritted
gitted84015053__gitted
gritted94110903_gritted
imitated1138263_imitated
kitted115114833__kitted
knitted12337423_knitted
limited102310233limi_ted
manumitted1552243manumitted
matted94521413__matted
milted93919943__milted
minted94220583__minted
misted93625823__misted
mitred94414343__mitred
mitten83914093__mitten
omitter9298503_omitter
permitted1446653permitted
pitted94319593__pitted
preadmitted1752803preadmitted
quitted17339893_quitted
radiated102512593rad_iated
reemitted1245943reemitted
refitted12309413refitted
reminted113615083reminted
remitter102810323remitter
shitted114212053_shitted
slitted83513313_slitted
smitten936693_smitten
smutted1037463_smutted
spitted103912703_spitted
submitted1445233submitted
twitted11326633_twitted
unbitted1138213unbitted
unfitted1238163unfitted
unmatted1138293unmatted
unmitred1136843unmitred
unpitted1148623unpitted
unwitted1237543unwitted
vomited1337253vomi_ted
wadsetted1442623wadsetted
witted104216813__witted

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.406440125.6
2DLD Change Limit1461621096.59322169.3
3Display Results1091090.0462369.6
 (SQL Overall)1786911097.04525364.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.