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

95 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
reasserts94598(None) 
reassert8313671reassert_
reassorts945621reassorts
asserts74311792__asserts
desserts9247922de_sserts
reascents1177402reascents
reasserted1145412reasserted
reassess836512reasse_ss
reassort8410682reassort_
reassures937222reassures
reinserts946422reinserts
amassers10337843amasser_s
assents74512223__assents
assert64922583__assert_
assets65617663__asse_ts
assorts73310153__assorts
bassets96414823_basse_ts
bassetts10407373_bassetts
brassarts1143823brassarts
classers104111833classer_s
creasers103612843crea_ser_s
cressets10309103cre_sse_ts
degassers11354833degasser_s
deserts82513053de__serts
dessert82916453de_ssert_
disserts92411813_disserts
dressers9359863dre_sser_s
easters75125683_easter_s
erasers74413943era_ser_s
exserts1467013_e_xserts
feasters11511563feaster_s
gassers84714633_gasser_s
greasers93410253grea_ser_s
headsets1236053headse_ts
leasers74717843lea_ser_s
overasserts1453553overasserts
passers94717753_passer_s
preassures1245273preassures
preinserts1243973preinserts
pressers103215023pre_sser_s
raisers73617393r_aiser_s
rasers64526783r_a_ser_s
rashers104020913r_asher_s
raspers94415923r_asper_s
rasters74629023r_aster_s
reabsorbs1342693reabsorbs
reaccents1365853reaccents
reaccepts1583213reaccepts
reachers133515723reacher_s
readers83823773rea_der_s
reagents959623rea_gents
realisers9248323realiser_s
realters83614043realter_s
reamers94221083rea_mer_s
reapers93520453rea_per_s
rearers74323563rea_rer_s
rearrests945313rearrests
reascends1244293reascends
reascent10411983reascent_
reasoners947113reasoner_s
reassails945293reassails
reasserting1246153reasserting
reassertion1154023reassertion
reassertions1253643reassertions
reassesses945063reassesses
reassigns1074353reassigns
reassorted1144363reassorted
reassumes1144463reassumes
reassure847343reassur_e
reassured1046103reassured
reavers108320743rea_ver_s
redshirts1342903redshirts
redstarts1044243redstarts
refusers11499273refuser_s
reinsert8313223reinsert_
reissuers954033reissuer_s
relapsers1164123relapser_s
remasters11310583remaster_s
repasses101810373repasse__s
reposers102911603reposer_s
reseats74319583re__seats
resects94115593re__sects
resents74221223re__sents
resets65427613re__se_ts
resmelts1046143re_smelts
resorts74817193re__sorts
respects1247703re_spects
restarts8310873re_starts
resters74130403re_ster_s
reverts104715043re__verts
revisers113511933reviser_s
roasters83615933roaster_s
russets738163r_usse_ts
tassets75012773_tasse_ts
teasers75317243tea_ser_s

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 Filter1786911486410.420425454.8
2DLD Change Limit148641956.62622433.0
3Display Results95950.0462065.2
 (SQL Overall)178691957.09225196.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.