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

138 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
apyrases133724(None) 
apyrase1236361apyrase_
amylases1346662amylases
appeases1238662appeases
appraises1347422appraises
apprises12310962apprises
arrases71214542a_rrases
gyrases11368312_gyrases
papyruses1643222papyruses
phrases12711462_phrases
prases84429022_p_rases
abases85720773a__bases
abrades10312073a_brades
abysses1234863aby_sses
acariases1146613acariases
acylates1339743acylates
aerates74627493a_erates
agaroses938823agaroses
aggrades1135863aggrades
agrafes1137523a_grafes
aliases7914493a_liases
amidases1136653amidases
amirates101114793amirates
amperages1447683amperages
amylase1237023amylase_
amyloses1347223amyloses
anabases1038083anabases
anatases839793anatases
anlases72514903a_nlases
anureses837973anureses
apanages1137013apanages
aperies9423203aper_ies
aphereses1466423aphereses
apheses12610703ap_heses
aphorises14310003aphorises
apiaries10312733apiaries
apoapses1244723apoapses
apodoses1136653apodoses
apophases1647973apophases
appease1137913appease_
appeased1335793appeased
appeaser1245953appeaser
appeasers1345263appeasers
applauses1344033applauses
apposes11511473ap_poses
appraise1247703appraise_
appraised1445593appraised
appraisee1345973appraisee
appraisees1443153appraisees
appraiser1344953appraiser
appraisers1443503appraisers
apprise11310193apprise_
apprised1337713apprised
appriser1246783appriser
apprisers1345053apprisers
apprizes2137793apprizes
approves15126833approves
appulses1234893appulses
apres75426403ap_r__es
apses76823913ap___ses
arames84622573a__rames
arises65233803a__rises
arrased8149863a_rrased
arrises71617583a_rrises
arses55733873a__r_ses
asperates11312553asperates
asperses104111673asper_ses
aspirates1139613aspirates
asynapses1442023asynapses
atlases72410643a_tlases
averages1249183averages
avgases11106313a_vgases
azygoses2163313azygoses
capiases1239253cap_iases
charases131312763charases
crases85532313__crases
cycases1437533_cycases
cypreses1535143cypreses
cypruses1534313cypruses
epitases1038933epitases
erases64425403__erases
eyases94513683_ey_ases
gyrase10508773_gyrase_
gyrates113610263_gyrates
hydrases15227643hydrases
hyraces1537913_hyraces
hyraxes2045703_hyraxes
lyases95211873_ly_ases
madrases112610003madrases
myases113711553_my_ases
myiases1235493_myiases
operates10515413operates
parades104121463_parades
pareses94718883_pareses
parises94827183_parises
parses85534703_par_ses
pases75346503_p__ases
paygrades1643623paygrades
peases85229473_p_eases
perses85428063_per_ses
peruses94018163_peruses
phases114618403_p_hases
phrase11109903_phrase_
phrased1387383_phrased
pirates93020333_pirates
pleases94515483_pleases
praises94121103_p_raises
prase76128753_p_rase_
prates84633163_p_rates
praxes156215183_p_raxes
prises84133173_p_rises
proses84733473_p_roses
purses84826373_pur_ses
pyoses114314303_py_oses
pyranoses1445853_pyranoses
pyrans11411063_pyra_ns
pyrenes123511223_pyrenes
pyres105523883_pyr__es
pyrexes19305843_pyrexes
pyrites12812203_pyrites
pyrones123113303_pyrones
pyropes142210193_pyropes
pyrosis12411653_pyrosis
rases55447213___rases
rephrases1447413rephrases
satyriases1343163satyriases
styraxes1833493styraxes
sucrases10310253sucrases
terrases82111483terrases
thyrses1335023thyr_ses
upases84112903up__ases
upgrades12216063upgrades
upraises10188473up_raises
uprates93814863up_rates
uprises92012733up_rises
urases63723563__urases
vaporises14209453vaporises
zymases21938333_zymases

Search took 9 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.436409841.7
2DLD Change Limit1461621388.33017546.5
3Display Results1381380.0632190.5
 (SQL Overall)1786911388.82920239.1
 
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.