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

142 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
relapser103527(None) 
relapse947701relapse_
relapsed1136531relapsed
relapsers1164121relapsers
relapses1038031relapses
elapse857522_elapse_
elapsed1056112_elapsed
elapses957662_elapses
lapser84113142__lapser
realiser82512562realiser
reaper84223142re_ap_er
relater73723142rela_ter
relaxer143410222rela_xer
releaser839502releaser
repaper11310022repap_er
belayer12339503bela_yer
clapper134011863_clapper
clasper113811863_clasper
classer93614613_classer
cleanser10356323cleanser
creaser94415743cre_a_ser
debaser103510413deba_ser
degasser10325813degasser
delayer113010533dela_yer
delouser936363delouser
eclipser1242803eclipser
elater64724203_ela_ter
eloper85414153_elop_er
eraser64216333_era_ser
flapper14359203_flapper
greaser83913083gre_a_ser
heaper114119523he_ap_er
helper114313093hel_p_er
lapper104319953__lapper
lapse74917683__lapse_
lapsed94712583__lapsed
lapsers93911053__lapsers
lapses85217693__lapses
laser54633323__la_ser
leaper88118943le_ap_er
leaser65322673le_a_ser
pleaser93912343plea_ser
prolapse12134913prolapse_
prolapsed14133733prolapsed
prolapses13145573prolapses
raiser66620103r__aiser
raper74932753r__ap_er
rapier84019993r__apier
rapper104621573r__apper
raser55633413r__a_ser
rasper83917333r__asper
reacher123718293re_acher
reader73628293re_a_der
readier83117423re_adier
realer63528593re_a_ler
realise73021813realise_
realised92214533realised
realisers9248323realisers
realises82420183realises
realizer172412113realizer
realter73716313re_alter
reamer84325213re_a_mer
reaped94122453re_ap_ed
reapers93520453re_ap_ers
reappear1242623re_appear
reaps75626193re_aps__
rearer64928913re_a_rer
reassert8313673re_assert
reaver94524733re_a_ver
rebater93517913reba_ter
recaller1039323recaller
recamier1237603recamier
recanter101913153recanter
recapped1535953recapped
recaps103615733recaps__
reclaimer1344463reclaimer
reclasped1444873reclasped
refuser104912783re_fuser
regainer9249353regainer
regaler83814623rega_ler
regather1236733regather
rehabber1563153rehabber
rehammer1544653rehammer
rehearser12265033rehearser
relabel938163rela_bel
relace83122153rela_ce_
relaced103517213rela_ced
relaces93420883rela_ces
relacquer2042193relacquer
relanded102410463relanded
relapsing1236843relapsing
relate64033633rela_te_
related83327573rela_ted
relaters83218153rela_ters
relates73731443rela_tes
relator74016383rela_tor
relaunder1053703relaunder
relaxed153312533rela_xed
relaxers15298263rela_xers
relaxes143215323rela_xes
relayed113212753rela_yed
relays94316753relays__
release7312763release_
released9310243released
releasers937323releasers
releases8313343releases
reletter81311023reletter
relier65826183rel__ier
reliever11448683reliever
reloader937913reloader
remaker133813173rema_ker
remapped1534913remapped
remaps105012873remaps__
remarker14178493remarker
remaster10311473remaster
repairer1036783repairer
repapers1258833repap_ers
repassed11229273repassed
repasses101810373repasses
replacer12279743repla_cer
replaster1136583replaster
reposer93715333re_poser
repulser1035803repulser
reraise7316313reraise_
reraised9312363reraised
reraises8415643reraises
reshaper1336913reshap_er
retailer82911573retailer
retainer82913813retainer
retaker113714313reta_ker
retape83917683retap_e_
retaped103814283retap_ed
retapes93917423retap_es
retarder9229433retarder
revamper1533533revamper
reverser113010483reverser
reviser104114673re_viser
rewarder12208233rewarder
slapper113512473_slapper
teaser65421523te_a_ser
telpher1235563tel_pher
yelper11458783yel_p_er

Search took 9 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.436409841.7
2DLD Change Limit1461621427.76618820.8
3Display Results1421420.0632254.0
 (SQL Overall)1786911428.26521620.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.