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

148 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
reassert831367(None) 
reasserts945981reasserts
reassort8410681reassort
assert64922582__assert
dessert82916452de_ssert
reascent10411982reascent
reasserted1145412reasserted
reassess836512reassess
reassorts945622reassorts
reassure847342reassure
reinsert8313222reinsert
amasser9418733amasser_
amassers10337843amassers
assent65119953__assent
asserts74311793__asserts
asset55932263__asse_t
assort64916383__assort
basset85225383_basse_t
bassett94213863_bassett
brassart1047503brassart
classer93614613classer_
classers104111833classers
crasser94114343crasser_
crassest103411523crassest
creaser94415743crea_ser_
creasers103612843crea_sers
creasier103210193creasier_
creasiest11229943creasiest
cresset93319943cre_sse_t
degasser10325813degasser_
degassers11354833degassers
desert72725493de__sert
desserts9247923de_sserts
dissert83720693_dissert
dresser83611953dre_sser_
dressers9359863dre_ssers
easier64218463_easier_
easiest72318773_easiest
easter65027983_easter_
eastern74412533_eastern
easters75125683_easters
eraser64216333era_ser_
erasers74413943era_sers
exsert13414363_e_xsert
feaster10812983feaster_
feasters11511563feasters
gasser75017773_gasser_
gassers84714633_gassers
greaser83913083grea_ser_
greasers93410253grea_sers
greasier9298083greasier_
greasiest10208563greasiest
headset11312603headse_t
leaser65322673lea_ser_
leasers74717843lea_sers
lesser63514853le_sser_
overassert1346503overassert
passer84721033_passer_
passers94717753_passers
preassure1145623preassure
preinsert1148573preinsert
presser93717623pre_sser_
pressers103215023pre_ssers
raiser66620103r_aiser_
raisers73617393r_aisers
raser55633413r_a_ser_
rasers64526783r_a_sers
rasher95024123r_asher_
rashers104020913r_ashers
rashest103916873r_ashest
rasper83917333r_asper_
raspers94415923r_aspers
raster64731443r_aster_
rasters74629023r_asters
reabsorb1243353reabsorb
reaccent1278573reaccent
reaccept1465123reaccept
reacher123718293reacher_
reachers133515723reachers
reader73628293rea_der_
readers83823773rea_ders
readier83117423readier_
readiest93719043readiest
reagent8716603rea_gent
realer63528593rea_ler_
realest73322433rea_lest
realiser82512563realiser_
realisers9248323realisers
realter73716313realter_
realters83614043realters
reamer84325213rea_mer_
reamers94221083rea_mers
reaper84223143rea_per_
reapers93520453rea_pers
rearer64928913rea_rer_
rearers74323563rea_rers
rearrest8311603rearrest
reascend1145703reascend
reascents1177403reascents
reasoner849343reasoner_
reasoners947113reasoners
reassail845753reassail
reasserting1246153reasserting
reassertion1154023reassertion
reassign955423reassign
reassorted1144363reassorted
reassume1044633reassume
reassured1046103reassured
reassures937223reassures
reaver94524733rea_ver_
reavers108320743rea_vers
redshirt1245853redshirt
redstart949193redstart
refuser104912783refuser_
refusers11499273refusers
reinserts946423reinserts
reissuer854523reissuer_
reissuers954033reissuers
relapser1035273relapser_
relapsers1164123relapsers
remaster10311473remaster_
remasters11310583remasters
renascent1147483renascent
repassed11229273repasse_d
repasses101810373repasse_s
reposer93715333reposer_
reposers102911603reposers
reseat64131493re__seat
resect84424703re__sect
resent63833623re__sent
reset55051863re__se_t
resmelt9411773re_smelt
resort65728623re__sort
respect11412033re_spect
respelt9312143re_spelt
restart7320033re_start
rester63832433re_ster_
resters74130403re_sters
revert93529113re__vert
reviser104114663reviser_
revisers113511933revisers
roaster74116663roaster_
roasters83615933roasters
russet6319433r_usse_t
tasset65925313_tasse_t
teaser65421523tea_ser_
teasers75317243tea_sers
tessera736333te_ssera

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.420425454.8
2DLD Change Limit1461621487.34319904.9
3Display Results1481480.0502960.0
 (SQL Overall)1786911487.81322871.0
 
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.