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 “admitting” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

93 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
admitting134503(None) 
addicting1485072addicting
admiring1236132admi_ring
admixing1944132admi_xing
coadmitting1752612coadmitting
demitting13239072demitting
emitting112410352_emitting
omitting11217742_omitting
readmitting1544052readmitting
remitting122412622remitting
abetting1158293a_betting
abutting1137003a_butting
acquitting2243653acquitting
adapting1236643ad_apting
adducting1494303adducting
adhibiting1742773adhibiting
adjusting1843833adjusting
admittance1552393admittance
admitted1234763admitt_ed
admittee1145133admitt_ee
admittees1243273admittees
admitter1135113admitt_er
admitters1244553admitters
adopting1237453ad_opting
adulating1178723adulating
advecting1645113advecting
adverting1437223adverting
advising1336153advi_sing
agisting1038243a_gisting
agitating1138863a_gitating
airting83616303a__irting
allotting1046503allotting
animating12312513animating
anointing1038623anointing
arointing1049363arointing
assisting1046183assisting
attritting1144763attritting
auditing1039033audi_ting
aviating12311033a_viating
awaiting1238273awai_ting
babbitting1443003babbitting
befitting15236623befitting
bemisting1438073bemisting
bitting103717293__bitting
committing1746683committing
dieting93616833_d_ieting
dinting93520553_d_inting
dittoing1036263_d_ittoing
dotting93314483_d_otting
dratting10389663_dratting
drifting13338733_drifting
duetting1047183_duetting
editing9313133ed_i_ting
fitting113516563__fitting
flitting123010883_flitting
fritting123510703_fritting
gitting93215703__gitting
gritting10309983_gritting
hitting113017273__hitting
imitating1238763_imitating
kitting123214443__kitting
knitting13257023_knitting
limiting1138813limi_ting
manumitting1652473manumitting
matting103620143__matting
milting103619123__milting
minting103020813__minting
misting103623383__misting
mitring103514143__mitring
permitting1546303permitting
pitting103618873__pitting
preadmitting1852763preadmitting
quitting18228833_quitting
radiating111112133rad_iating
reemitting1346633reemitting
refitting132811123refitting
reminting122315103reminting
resitting103414873resitting
shitting123212663_shitting
sitting83519633__sitting
slitting93012583_slitting
smiting103014443_smi_ting
smutting11278063_smutting
spitting113012323_spitting
splitting1236563splitting
submitting1544973submitting
twitting12307223_twitting
unfitting1336423unfitting
unmitring1245263unmitring
unwitting1335583unwitting
vomiting1437733vomi_ting
wadsetting1542913wadsetting
witting113417063__witting

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 Filter1786911486410.436409841.7
2DLD Change Limit148641936.86021667.8
3Display Results93930.0303100.0
 (SQL Overall)178691937.32624391.3
 
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.