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

143 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
remotest10331072(None) 
remotes94521611remotes_
demotes104717672demotes_
demotist11311842demotist
emotes84620282_emotes_
gemotes103712142gemotes_
reforest1139962reforest
remates93827112remates_
remote84222602remote__
remotely1345622remotely
remoter94815972remote_r
removes124514712removes_
retest64028452re__test
revotes104716392revotes_
cenotes92814543cenotes_
cremates124216003cremates_
deforest1238793deforest
deftest112611713de_ftest
demoness1138053demoness
demonist11413463demonist
demoses103815823demoses_
demote94817803demote__
demoted114313543demote_d
demotists1247323demotists
demurest1137453demurest
denotes83817003denotes_
detest74122843de__test
devotes113713753devotes_
devoutest1343643devoutest
egotist8411273_egotist
emote75421193_emote__
emoted94614923_emote_d
emoter85415193_emote_r
emoters94712873_emoters
emptiest1278103_emptiest
eremites10312603eremites_
featest102715113fe_atest
gemmiest13227623gemmiest
gemote94613023gemote__
gemots93712153gemot_s_
greatest939863gre_atest
hempiest1539023hempiest
immodest1344543immodest
leftest10269463le_ftest
modest93818453__modest
molest85022743__molest
mostest9314793__mostest
motes75944003__motes_
motet75641193__mote_t
motets84216193__motets
mutest84218053__mutest
neatest72516003ne_atest
nepotist1059233nepotist
peartest10311303peartest
pertest9317043pe_rtest
peyotes1238483peyotes_
prepotent1349573prepotent
pretest9517633pre__test
promotes12314123promotes_
promptest1546063promptest
protest9317533_protest
rammiest12299933rammiest
readiest93719043readiest
realest73322433re_alest
rearrest8311603rearrest
rebates95123183rebates_
rebores95319163rebores_
recentest11410283recentest
recites93524583recites_
recodes102918633recodes_
redates83423873redates_
reddest9311953re_ddest
redigest1039733redigest
redoes74623763redo_es_
redolent9411883redolent
redoxes15310883redoxes_
reediest92815423reediest
reefiest112811483reefiest
reekiest122711313reekiest
reest54938093re___est
reforests1245533reforests
refutes104515723refutes_
reinvest1138203reinvest
relates73731433relates_
remakes134116173remakes_
remanent10311703remanent
remate84428683remate__
remated103522473remate_d
remeet86325473rem__eet
remeets93712413remeets_
remelt85123123rem__elt
remet74843723rem__e_t
remiges103015473remiges_
remises93423483remises_
remitment1349443remitment
remits85622943remit_s_
remittent1148273remittent
remixes164313873remixes_
remodel1038093remode_l
remodels1135663remodels
remolds10299703remolds_
remontant1148093remontant
remoras9314073remoras_
remorse9311713remo_rse
remorses10311993remorses
remoteness1246683remoteness
remotion10410233remotion
remount9512283remo_unt
remounts1036373remounts
remove116115573remove__
removed134611313remove_d
remover124612273remove_r
removers13449223removers
renest64529713re__nest
renitent8315333renitent
rentes65431193re_ntes_
reposes94021263reposes_
repots85621003repot_s_
reputes94615963reputes_
request16311023re_quest
reroutes8312223reroutes_
resites74027793resites_
resojet14312823resoje_t
resojets1535343resojets
resoles73823653resoles_
resolutest1053923resolutest
retests73813853re__tests
revest94623603re__vest
revokes144212503revokes_
revote94917453revote__
revoted114314153revote_d
rezones163213943rezones_
rightest12149583rightest
rimiest93215853rim_iest
roomiest102611993roomiest
rootiest83115593r_ootiest
rotes56143903r__otes_
rummest11279833rum_mest
rummiest12299353rummiest
sedatest9249393sedatest
semitist10413323semitist
tempest1139223tem_pest
wettest10239363we_ttest

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.423422437.4
2DLD Change Limit1461621437.31319986.6
3Display Results1431430.0463108.7
 (SQL Overall)1786911437.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.