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

128 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
deposit1031300(None) 
deposits1138841deposits
reposit9315861reposit
deport94922392depo_rt
deposal1037152deposal
depose94215762depos_e
deposed113412022deposed
deposer104011842deposer
deposes103117212deposes
deposing12129772deposing
deposited1346772deposited
depositor1244442depositor
depot85727922depo__t
exposit1649682exposit
posit75833332__posit
redeposit1245352redeposit
reposits10310452reposits
adenosis946343adenosis
adiposis1146253adiposis
adiposity1544103adiposity
aerosat7417183aerosat
apposite12410013apposite
bedpost1247243bedpos_t
bedsit9312843be_dsit
bevomit1445353bevomit
celosia939463celosia
dacoit9415453daco_it
dakoit11310343dako_it
deasil71110983de_asil
debit85727853de__bit
deceit93018213de_ceit
decoct11313783deco_ct
decos85522123decos__
deepest10310443deepes_t
deficit1339673deficit
defrost1139553defros_t
degust8310253degus_t
dehort104618103deho_rt
deist64633593de_is_t
delimit10311733delimit
delist74625053delis_t
demast9517063demas_t
demerit10314993demerit
demit84832303de__mit
demonic12311223demonic
demonist11413463demonist
demos86022993demos__
demoses103815823demoses
demotic12412333demotic
demotist11311843demotist
demount1049743demount
density1137583de_nsity
dentist8316743dentist
deorbit1048163deorbit
depaint10314593depaint
depart94720563dep_art
depict113514793dep_ict
depolish1446943depolish
depone93616553depo_ne
deponed113712873deponed
deponent11410553deponent
depones103717093depones
deponing121211213deponing
deports105012883deports
deposals1145433deposals
deposers11359243deposers
depositary1652383depositary
depositing1446933depositing
deposition13107823deposition
depositors1344033depositors
depository1653253depository
depots94716343depo_ts
depside1138403dep_side
desist74818813de__sist
despoil1046523despo_il
despot93413293despo__t
despotic1346533despotic
detest74122843detes_t
devest104418703deves_t
devoid1189363devo_id
devoir1076033devo_ir
devout10712993devo_ut
diplosis11128413diplosis
dipodic1397593dipodic
dipshit1347993dipshit
doit56347853d__o_it
dost57248353d__os_t
droit65127123d_ro_it
egoist7612283_egoist
enosis63816423_enosis
eosin55220923_e_osin
epos66723733_epos__
eposes84418783_eposes
exposits1747243exposits
gaposis1038423gaposis
impost103011783impos_t
kenosis11369003kenosis
ketosis11429733ketosis
leporid1048153leporid
meiosis939023meiosis
nepotic11310553nepotic
nepotist1059233nepotist
opposite1247133opposite
oviposit13375613oviposit
pepos96620083pepos__
pepsin10310853pep_sin
posits85718713__posits
post67953363__pos_t
prosit85124593_prosit
redeposits1353533redeposits
repast83520633repas_t
report85326013repo_rt
repos74725793repos__
reposal939113reposal
repose84121413repos_e
reposed103616273reposed
reposer93715333reposer
reposes94021263reposes
reposing111213803reposing
reposited1239133reposited
repot75132623repo__t
resit54241043re__sit
revisit10311373revisit
ripost83615003ripos_t
sepsis83011293sep_sis
serosity1148783serosity
venosity1446023venosity
xerosis14249663xerosis

Search took 9 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.1561145455.1
2DLD Change Limit1340271287.78017227.1
3Display Results1281280.0462782.6
 (SQL Overall)1786911287.98222386.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.