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

104 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
apprized223654(None) 
apprised1337711apprised
apprize2038181apprize_
apprizer2145461apprizer
apprizes2137791apprizes
aphorized2446442aphorized
applied1247482appli_ed
appraised1445592appraised
apprise11310192apprise_
appriser1246782appriser
apprises12310962apprises
apprizers2243832apprizers
approved16115072approved
prized184415392__prized
unprized2038512unprized
vaporized24227352vaporized
aeried74221863a_eri_ed
agatized1947073agatized
agenized19257733agenized
agnized18247223a_gnized
agonized19258993agonized
amortized2185933amortized
anodized1946463anodized
aperies9423203aperi_es
aphorised1546363aphorised
aphorize2249043aphorize_
aphorizer2345403aphorizer
aphorizes2348013aphorizes
appalled1344813appalled
appareled1442893appareled
appealed1335603appealed
appeared1336143appeared
appeased1335793appeased
appended1435483appended
appetizer2244433appetizer
applier1137903appli_er
applies11311213appli_es
appliqued2341953appliqued
appointed1444803appointed
apposed1247853app_osed
appraise1247703appraise_
appraisee1345973appraisee
appraiser1344953appraiser
appraises1347423appraises
apprehend1743103apprehend
appressed1445943appressed
apprisers1345053apprisers
apprizing2347193apprizing
approve14116603approve_
approver15105303approver
approves15126833approves
aproned10311503a_proned
arabized2047173arabized
arborized2166973arborized
ariled75620323a__riled
arrived11127353a_rrived
ascribed1374693ascribed
aspired1068173asp_ired
atomized20279323atomized
attrited947373attrited
azotized1745673azotized
baptized2245483baptized
calorized21249663calorized
caponized2347073caponized
capsized2255493capsized
comprized2567223comprized
deprived1546463deprived
disprized2247363disprized
emprize2038843emprize_
emprizes2138133emprizes
frized193510683__frized
japanized2844733japanized
laterized1979903laterized
maderized2247023maderized
misprized2346603misprized
odorized1945843odorized
parried103615723parri_ed
pauperized2443753pauperized
peptized22237523peptized
periled10316323_periled
priced115018883__priced
prided103618033__prided
pried84426863__pri_ed
primed115118913__primed
prised94322203__prised
prize164718943__prize_
prizer174714883__prizer
prizes173819813__prizes
repriced132610543repriced
reprised112012203reprised
satirized1957893satirized
spirited1148973spirited
spritzed2044803_spritzed
surprized2144663surprized
unpriced1338143unpriced
unprimed1337203unprimed
updried11226473updri_ed
uppiled12216593upp_iled
upsized19246253_upsized
valorized22257723valorized
vaporised15216953vaporised
vaporize22239173vaporize_
vaporizer23236143vaporizer
vaporizes23228523vaporizes

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.436409841.7
2DLD Change Limit1461621046.76621602.4
3Display Results1041040.0462260.9
 (SQL Overall)1786911047.24824653.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.