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

114 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
relapsers116412(None) 
relapser1035271relapser_
relapses1038031relapse_s
elapses957662_elapse_s
lapsers93911052__lapsers
realisers9248322realisers
reapers93520452re_ap_ers
relapse947702relapse__
relapsed1136522relapse_d
relaters83218152rela_ters
relaxers15298262rela_xers
releasers937322releasers
repapers1258832repap_ers
belayers13298143bela_yers
clappers143310833_clappers
claspers124410913_claspers
classers104111833_classers
cleansers11335073cleansers
creasers103612843cre_a_sers
debasers11377903deba_sers
degassers11354833degassers
delayers12268663dela_yers
delousers1044663delousers
eclipsers1342643eclipsers
elapse857523_elapse__
elapsed1056103_elapse_d
elaters74420193_ela_ters
elopers95112943_elop_ers
erasers74413943_era_sers
flappers15388383_flappers
greasers93410253gre_a_sers
heapers123616673he_ap_ers
helpers123311853hel_p_ers
lappers113717463__lappers
lapser84113143__lapser_
lapses85217693__lapse_s
lasers64925703__la_sers
leapers93716663le_ap_ers
leasers74717843le_a_sers
pleasers104010293plea_sers
prolapses13145573prolapse_s
raisers73617393r__aisers
rapers84327183r__ap_ers
rapiers95012873r__apiers
rappers113618443r__appers
rasers64526783r__a_sers
raspers94415923r__aspers
reachers133515723re_achers
readers83823773re_a_ders
realiser82512563realiser_
realises82420183realise_s
realizers18237933realizers
realters83614043re_alters
reamers94221083re_a_mers
reaper84223143re_ap_er_
reappears1342853re_appears
rearers74323563re_a_rers
reassert8313673re_assert
reasserts945983re_asserts
reassess836513re_assess
reavers108320743re_a_vers
rebaters103413943reba_ters
recallers1137103recallers
recamiers1345513recamiers
recanters112310483recanters
reclaimers1443593reclaimers
refusers11499273re_fusers
regainers10237383regainers
regalers94311133rega_lers
regathers1336353regathers
rehabbers1683133rehabbers
rehammers1644503rehammers
rehearsers13273863rehearsers
relabels1045343rela_bels
relaces93420883rela_ce_s
relacquers2142023relacquers
relapsing1236843relapsing
relater73723143rela_ter_
relates73731433rela_te_s
relators83316123rela_tors
relaunders1153103relaunders
relaxer143410223rela_xer_
relaxes143215323rela_xe_s
releaser839503releaser_
releases8313343release_s
reletters9138783reletters
reliers75519213rel__iers
relievers12387063relievers
reloaders1036423reloaders
remakers143811303rema_kers
remarkers15197283remarkers
remasters11310583remasters
repairers1135283repairers
repaper11310023repap_er_
repasses101810373repasse_s
replacers13266833repla_cers
replasters1245533replasters
reposers102911603re_posers
repulsers1144713repulsers
reraises8415643reraise_s
reshapers1435493reshap_ers
retailers9258773retailers
retainers92510763retainers
retakers123511133reta_kers
retapes93917423retap_e_s
retarders10227573retarders
revampers1653443revampers
reversers12298483reversers
revisers113511933re_visers
rewarders13226453rewarders
slappers123710943_slappers
teasers75317243te_a_sers
telphers1335473tel_phers
yelpers12348203yel_p_ers

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.406440125.6
2DLD Change Limit1486411146.79621871.8
3Display Results1141140.0631809.5
 (SQL Overall)1786911147.26524596.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.