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

153 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
despiser113634(None) 
despise1038681despise_
despised1236921despised
despisers1245151despisers
despises1139431despises
deposer104011842de_poser
desirer8310782des_irer
despairer1243692despairer
despisal1144672despisal
despite10410122despite_
despited1248322despited
despites11410312despites
despoiler1243962despoiler
deviser114212392de_viser
disposer11310412disposer
aspirer967903_aspirer
aspises9611643_aspises
beshiver1634483beshiver
dashier114311183dashi_er
debaser103510413de_baser
deceiver1436233deceiver
decider114213183de_cider
decipher1644423decipher
decliner113710843decliner
decrier102713553decri_er
deedier93011593deedi_er
deepener1145183deepener
deeper93613503deep__er
defier105118653de_fi_er
defiler113911883de_filer
definer114413773de_finer
defuser115110503de_fuser
degasser10325813degasser
deicer94114413de__icer
deifier113013123deifi_er
deixises1635693deixises
deliver113312243de_liver
delouser936363delouser
demise94618323de_mise_
demised113613683de_mised
demises103719563de_mises
demister11310223de_mister
dempster1355773dempster
denier74420693de_ni_er
denser74115193de__nser
depicter1356853de_picter
depose94215763de_pose_
deposed113412023de_posed
deposers11359243de_posers
deposes103117213de_poses
depriver1446293depriver
depside1138403depside_
depsides1238503depsides
derider93214973de_rider
deriver114213913de_river
dermises112512023dermises
dernier83011943derni_er
derrises93012783derrises
desalter938363desalter
describer1444613describer
descrier1157623descrier
deserter91211603deserter
deserver12118383deserver
designer1036543designer
desilver12286503desilver
desire7415303des_ire_
desired9311983des_ired
desirers939263des_irers
desires81316133des_ires
desist74818813des_is_t
desisted1039783des_isted
desists83611723des_ists
despair1045463desp_air
despaired1344503despaired
despairers1343103despairers
despisals1243503despisals
despising13167503despising
despoiled1344653despoiled
despoilers1343533despoilers
dessert82916453des__sert
destine83719953destine_
destined103312453destined
destines93619663destines
destrier9311823destrier
detailer9268673detailer
detainer92910793detainer
devise104215753de_vise_
devised123712563de_vised
devisee113812713de_visee
devisers12339863de_visers
devises114116763de_vises
devisor11357043de_visor
dewier104013463de_wi_er
dippier123111393dippi_er
disguiser1145093disguiser
dishier113613403dishi_er
disliker13358643disliker
dispenser12128323dispenser
disperser12109083disperser
dispose10312763dispose_
disposed12310943disposed
disposers1238373disposers
disposes11313823disposes
dispraiser1345103dispraiser
disputer1137973disputer
dopier93515923d_opi_er
dosser74417973dos__ser
dossier83711693dossi_er
dresser83611953dres__ser
dressier956863dressi_er
dumpier12409653dumpi_er
duskier12409433duski_er
dustier83814133dusti_er
epimer10109153_e_pimer
espied9359773_espi_ed
espies83716803_espi_es
espouser1044383_espouser
expirer1635993_expirer
exposer1637413_exposer
hempier14319003hempi_er
inspirer1045183inspirer
lesser63514853les__ser
meshier123410853meshi_er
messier93412923messi_er
peppier10268323peppi_er
peskier13319113peski_er
pestier94317403pesti_er
raspier93110643raspi_er
realiser82512563realiser
repiner94816903re_piner
reposer93715333re_poser
resider84615803res_ider
resister8311653res_ister
respire9411543respire_
respired1148993respired
respires10311903respires
respite9513033respite_
respited11410813respited
respites10513243respites
reviser104114663re_viser
seepier92912013seepi_er
seiser65318343__seiser
spicer104719313__spicer
spider94516803__spider
spier75728033__spi_er
spiker124315663__spiker
testier74015643testi_er
vesper1138083vesp__er
vespine1237903vespine_
waspier12259053waspi_er
weepier12319273weepi_er
wispier12249403wispi_er
zestier163010223zesti_er

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.1531167915.0
2DLD Change Limit1461621537.67319048.9
3Display Results1531530.0632428.6
 (SQL Overall)1786911537.88922650.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.