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

127 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
apprised133771(None) 
appraised1445591appraised
apprise11310191apprise_
appriser1246781appriser
apprises12310961apprises
apprized2236541apprized
aphorised1546362aphorised
appeased1335792appeased
applied1247482appli_ed
apposed1247852app_osed
appraise1247702appraise_
appraisee1345972appraisee
appraiser1344952appraiser
appraises1347422appraises
appressed1445942appressed
apprisers1345052apprisers
apprize2038182apprize_
apprizer2145462apprizer
apprizes2137792apprizes
approved16115072approved
prised94322202__prised
reprised112012202reprised
vaporised15216952vaporised
abscised1364133abscised
advised12136043a_dvised
aeried74221863a_eri_ed
agonised10248483agonised
amortised1285813amortised
aperies9423203aperi_es
aphorise1339983aphorise_
aphorises14310003aphorises
aphorized2446443aphorized
appalled1344813appalled
appareled1442893appareled
appealed1335603appealed
appeared1336143appeared
appease1137913appease_
appeaser1245953appeaser
appeases1238663appeases
appended1435483appended
appetiser1344443appetiser
applier1137903appli_er
applies11311213appli_es
appliqued2341953appliqued
appointed1444803appointed
appose10411993app_ose_
apposer1147483app_oser
apposes11511473app_oses
appraisal1343633appraisal
appraisees1443153appraisees
appraisers1443503appraisers
apprehend1743103apprehend
apprising1447963apprising
apprizers2243833apprizers
approve14116603approve_
approver15105303approver
approves15126833approves
appulse1134673appulse_
appulses1234893appulses
aproned10311503a_proned
apyrase1236363apyrase_
apyrases1337243apyrases
ariled75620323a__riled
arise56436433a__rise_
arisen65316793a__risen
arises65233803a__rises
arrased8149863a_rrased
arrises71617583a_rrises
arrived11127353a_rrived
ascribed1374693ascribed
aspersed11428293aspersed
aspired1068173asp_ired
aspises9611643asp_ises
atomised11278833atomised
attrited947373attrited
axised14438963a__xised
azotised1844443azotised
baptised1335263baptised
comprised1648053comprised
deprived1546463deprived
emprise11310723emprise_
emprises12311003emprises
irised73913153__irised
opposed1236123opp_osed
oppressed1445123oppressed
parises94827183_parises
parried103615723parri_ed
parsed96323893_par_sed
peised94817683__peised
periled10316323_periled
perished14310083_perished
perused103112193_perused
phrased1387383_phrased
poised94918473__poised
praised104214813_praised
priced115018883__priced
prided103618033__prided
pried84426863__pri_ed
primed115118913__primed
prise74632613__prise_
prises84133173__prises
prissed103311263__prissed
prized184415393__prized
prosed94921093__prosed
pursed95220883_pur_sed
reappraised1672823reappraised
repriced132610543repriced
reprise92715043reprise_
reprises102615463reprises
satirised1046553satirised
spirited1148973spirited
surprised1245313surprised
unpoised1139183unpoised
unpriced1338143unpriced
unprimed1337203unprimed
unprized2038513unprized
updried11226473updri_ed
uppiled12216593upp_iled
upraised11167413upraised
uprise82313693_uprise_
uprisen9227353_uprisen
upriser9218763_upriser
uprises92012733_uprises
valorised13247103valorised
vaporise13209633vaporise_
vaporises14209453vaporises
vaporized24227353vaporized

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.420425454.8
2DLD Change Limit1461621276.29623215.1
3Display Results1271270.0462760.9
 (SQL Overall)1786911276.76226425.8
 
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.