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

70 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
reassort841068(None) 
reassert8313671reassert
reassorts945621reassorts
assort64916382__assort
reabsorb1243352reabsorb
reasserts945982reasserts
reassorted1144362reassorted
reassure847342reassure
resort65728612re__sort
assert64922583__assert
assorts73310153__assorts
brassart1047503brassart
dessert82916453de_ssert
escort84616483_e_scort
glasswort1344603glasswort
leadwort1247473leadwort
lessor64010603le_ssor_
lessors73610523le_ssors
missort9314653_missort
passport1247593_passport
preabsorb1542853preabsorb
preassure1145623preassure
presort95219533pre__sort
pressor93512873pre_ssor_
pressors103212683pre_ssors
ragwort11510733r_agwort
rapport11311223r_apport
rasbora945943r_asbora
reabsorbs1342693reabsorbs
reactor93011653reactor_
reactors103212283reactors
readopt10410843rea_dopt
readorn8310473rea_dorn
readout8615513rea_dout
reallot7312133reallo_t
realtor73611353realtor_
realtors82811683realtors
rearmost1047263rearmost
reascent10411983reascent
reason62616333rea_so_n
reasons72514943rea_sons
reassail845753reassail
reasserted1145413reasserted
reassess836513reassess
reassign955423reassign
reassorting1245023reassorting
reassume1044633reassume
reassured1046103reassured
reassures937223reassures
redshirt1245853redshirt
redstart949193redstart
reexport1745633reexport
reimport1246503reimport
reinsert8313213reinsert
report85326013re__port
rescore95616193re_score
reshoot102513893re_shoot
reshot93519633re_sho_t
resorb84914343re__sorb
resorts74817193re__sorts
respot83117633re_spo_t
restart7320033re_start
restore75822973re_store
retort66831143re__tort
revisor10388733revisor_
revisors11379063revisors
revisory14306013revisory
seaport9315593sea_port
seascout1047953seascout
seashore1147723seashore

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.1731032896.0
2DLD Change Limit146162707.57619292.8
3Display Results70700.0332121.2
 (SQL Overall)178691707.78222962.1
 
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.