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

116 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
emprize203884(None) 
emprise11310721emprise
emprizes2138131emprizes
apprize2038182apprize
comprize2368732comprize
empire1039322emp_ire
emprises12311002emprises
memorize211311102memorize
prize164718942__prize
temporize2246872temporize
amortize1987743amortize
apprise11310193apprise
apprized2236543apprized
apprizer2145463apprizer
apprizes2137793apprizes
baptize2036983baptize
caprice1349683caprice
caprine11314233caprine
capsize2037623capsize
comprise14310813comprise
comprized2567223comprized
comprizes2468943comprizes
cuprite1159683cuprite
demonize20311533demonize
deprive1338303deprive
dimerize2048113dimerize
disprize2048433disprize
ebonize1838153ebonize
eccrine1137283eccrine
eerie55228533e_eri_e
elegize17127383elegize
emblaze2045773emblaze
embrace1388893embrace
embrue1036533embr_ue
embrute1145703embrute
emerge91510463emer_ge
emeries91620023emeries
emerita938713emerita
emeritae1046353emeritae
emeriti949433emeriti
emetine9712943emetine
emirate91015833emirate
emotive1239193emotive
empale102611263emp_ale
empathize25103513empathize
emperies12314563emperies
emphasize25124933emphasize
empires1139853empires
empiric1345963empiric
empirics1444003empirics
emplace1338263emplace
emplane11410013emplane
employe1476363employe
emporia1148753empori_a
emporium1446173emporium
empress1138163empress
emptied1297393emptied
emptier1187603emptier
empties11712243empties
emptily1445813emptily
emptins1179403emptins
empurple1442183empurple
energize1845563energize
erotize16311663erotize
eserine7415903eserine
esprit8312843espri_t
esprits938393esprits
eternize17118363eternize
etherize2049463etherize
eucrite939903eucrite
exorcize2644893exorcize
expertize2746583expertize
expire1538023exp_ire
eyrie88117833e_yri_e
feminize22199373feminize
hempie132410563hemp_i_e
hemplike1936123hemplike
imprese1138143imprese
imprint11312563imprint
improve1435963improve
lemurine1046523lemurine
maize164618563_m_aize
marine84230403_marine
memorise121411433memorise
memorized23138993memorized
memorizer22137643memorizer
memorizes221310823memorizes
mesmerize2246033mesmerize
misprize2147543misprize
murine84220023_murine
odorize1737403odorize
overprize23118683overprize
peptize20279483peptize
price93725413__price
pride84724733__pride
prime96525603__prime
prise74632613__prise
prized184415393__prized
prizer174714883__prizer
prizes173819813__prizes
reprice113212833reprice
reprise92715043reprise
semplice1447013semplice
sempre102710093sempr__e
sprite84421773_sprite
surprize1945843surprize
temporise1347403temporise
temporized2446063temporized
temporizer2345233temporizer
temporizes2346933temporizes
umpire1047893ump_ire
unprized2038513unprized
uprise82313693_uprise
upsize17267303_upsize
vaporize22239173vaporize
velarize2048763velarize

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 Limit1340271165.76623244.4
3Display Results1161160.0462521.7
 (SQL Overall)1786911166.21828737.7
 
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.