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 “ourself” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

98 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
ourself105745(None) 
yourself1442651yourself
herself1337622herself
oneself1046072oneself
ousel55222402ou_sel_
ousels64815282ou_sels
outsell7109262outsell
bourse84414333bourse__
bourses94014303bourse_s
bursal84414823bursal_
burse75527253burse__
burseed1049503burseed
bursera936763bursera
burses84425513burse_s
coarsely1335533coarsely
counsel948543counsel_
counsels1037583counsels
course85117783course__
coursed104113603course_d
courser94114803course_r
coursers104412303coursers
courses94218893course_s
curse75829143curse__
cursed94321253curse_d
cursedly1444183cursedly
curser84721473curse_r
cursers94317163cursers
curses85328273curse_s
dorsel75315503dorsel_
dorsels84412583dorsels
fusel85218493fu_sel_
fusels94412453fu_sels
gunsel7339853gunsel_
gunsels8338133gunsels
himself1544293himself
hirsel9138683hirsel_
hirsels10128353hirsels
hisself1335913hisself
hoarsely1444373hoarsely
housel95217053hou_sel_
housels105312143hou_sels
itself946263_itself
jurel124516333jur_el_
jurels133710583jur_els
morsel85815893morsel_
morsels94112663morsels
mussel83412903mussel_
mussels9419843mussels
myself1445593_myself
nonself1078513nonself
nurse54420123nurse__
nursed74514673nurse_d
nurser64314503nurse_r
nursers74311833nursers
nursery10396023nursery
nurses63919353nurse_s
obesely1245113obesely
oriel54920423o_riel_
oriels64914623o_riels
ourebi837173our_ebi
ourie54027303ourie__
ours47237563ours___
ourselves1243673ourselves
outfelt10310603outfelt
outsee63121803outse_e
outseen72712333outseen
outsees72616433outsees
outsells888653outsells
outsert72819513outsert
outset64027453outse_t
outsets73514923outsets
outsmell1075523outsmell
outsmelt10138163outsmelt
outsold8109073outsold
outsole71013433outsole
outspell10125453outspell
outspelt10148403outspelt
outsulk1156323outsulk
outtell797883outtell
outyell1095843outyell
outyelp1294323outyelp
ouzel144612323ou_zel_
ouzels15408703ou_zels
oversell1137473oversell
purely114013633pur_ely
purse76028893purse__
pursed95220883purse_d
purser85020473purse_r
pursers93916093pursers
purses84826373purse_s
pursily1238213pursily
self75138293___self
surely93816463sur_ely
tersely1038113tersely
thyself1643033thyself
unsell63512543_unsell
wurzel1834993wurzel_
wurzels1934083wurzels

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 Limit134027985.90622693.4
3Display Results98980.0303266.7
 (SQL Overall)178691986.34228175.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.