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

118 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
apprize203818(None) 
apprise11310191apprise
apprized2236541apprized
apprizer2145461apprizer
apprizes2137791apprizes
aphorize2249042aphorize
appraise1247702appraise
apprised1337712apprised
appriser1246782appriser
apprises12310962apprises
apprizers2243832apprizers
approve14116602approve
emprize2038842emprize
prize164718942__prize
vaporize22239172vaporize
acarine9316003acarine
aerie54634603a_eri_e
agatize1739833agatize
agenize172910153agenize
agnize16329563a_gnize
agonize172911403agonize
alpine84417373alp_ine
amortize1987743amortize
anodize1738683anodize
apatite9312963apatite
apelike13310533apelike
aperies9423203aperies
aphorise1339983aphorise
aphorized2446443aphorized
aphorizer2345403aphorizer
aphorizes2348013aphorizes
aplite8316393a_plite
apocrine1246933apocrine
aporia8315863apori_a
aporias9315153aporias
appease1137913appease
appetite1258493appetite
appetizer2244433appetizer
apple94517673app__le
applied1247483applied
applier1137903applier
applies11311213applies
applique2142583applique
appoint11612483appoint
appose10411993app_ose
apposite12410013apposite
appraised1445593appraised
appraisee1345973appraisee
appraiser1344953appraiser
appraises1347423appraises
apprisers1345053apprisers
apprizing2347193apprizing
approved16115073approved
approver15105303approver
approves15126833approves
appulse1134673appulse
apyrase1236363apyrase
arabize1849343arabize
arborize1988963arborize
arise56436433a__rise
arrive91311793a_rrive
ascribe1147743ascribe
aspire8612123asp_ire
assize1538633a_ssize
astride8311973astride
atomize183111823atomize
attrite7311833attrite
avarice1238033avarice
azotize1537083azotize
azurite1638003azurite
baptize2036983baptize
calorize192712733calorize
caponize2139113caponize
caprice1349683caprice
caprine11314233caprine
capsize2037623capsize
comprize2368733comprize
cuprite1159683cuprite
deprive1338303deprive
disprize2048433disprize
emprise11310723emprise
emprizes2138133emprizes
japanize2645283japanize
laterize17613293laterize
maderize2049073maderize
misprize2147543misprize
nappie104112263napp_i_e
odorize1737403odorize
paprica1337003paprica
paprika1544003paprika
papyrine1546053papyrine
pauperize2244763pauperize
peptize20279483peptize
price93725413__price
pride84724733__pride
prime96525603__prime
prise74632613__prise
prized184415393__prized
prizer174714883__prizer
prizes173819813__prizes
purine85321893_purine
pyrite11913313_pyrite
reprice113212833reprice
reprise92715043reprise
sapphire1543803sapphire
satirize1749703satirize
sprite84421773_sprite
surprize1945843surprize
unprized2038513unprized
uppile10178503upp_ile
uprise82313693_uprise
upsize17267303_upsize
valorize20239613valorize
vaporise13209633vaporise
vaporized24227353vaporized
vaporizer23236143vaporizer
vaporizes23228523vaporizes
yperite1249893yperite

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271186.25021444.3
3Display Results1181180.0462565.2
 (SQL Overall)1786911186.70226662.3
 
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.