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

369 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
remoras931407(None) 
remora8414581remora_
fedoras1137922fedoras
femora1149582femora_
femoral1238722femoral
moras76438762__moras
premoral1249712premoral
ramonas9311092ramonas
rebores95319162rebores
records105213922records
recorks134813022recorks
redowas1138392redowas
reforms1239812reforms
remarks13329982remarks
remolds10299702remolds
remorid10311862remorid
remorse9311712remorse
remorses10311992remorses
remotes94521612remotes
removal1236732removal
removals1345642removals
removes124514712removes
remudas1035832remudas
reports94916212reports
resorbs95010522resorbs
resorts74817192resorts
retorts76016512retorts
rewords115413972rewords
reworks145113592reworks
rumors81110392rumor_s
senoras72714952senoras
tremors93711212tremor_s
agoras7613343_agoras
amoral8314623_amoral
angoras8811363angoras
areolas71013863are_olas
armors85017813armor_s
atemoyas1342853atemoyas
auroras7311703auroras
begorah1355593begorah
bemas96424283bem__as
bemires113212833bemires
bemoan10310253bemo_an
bemoans1138253bemoans
bemocks1735373bemocks
bevors111610343bevor_s
beworms1437913beworms
bezoars1836793bezoars
boras75938303__boras
cameras11313343cameras
camorras12116493camorras
ceorls848163ce_orls
cesuras958683cesuras
decors94017773decor_s
deforms1337803deforms
dehorns11428363dehorns
dehorts11379773dehorts
demarks14339233demarks
demobs11429483demo_bs
democrat1347943democrat
democrats1446203democrats
demons94917723demo_ns
demos86022993demo__s
demoses103815823demoses
demotes104717673demotes
demurs939773demur_s
deports105012883deports
desorbs10437713desorbs
deworms1338013deworms
dhooras1135943dhooras
embars103812873_embars
emirs76116153_emir_s
emotes84620283_emotes
eras45441503_e__ras
eremurus1042733eremurus
errors63311313error_s
extras13310223_extras
eyras84715923_e_yras
fedora1038593fedora_
femurs1136713femur_s
fetors91014473fetor_s
floras94715693_floras
gemotes103712143gemotes
gemots93712153gemo_ts
genoas74013623geno_as
hegiras1136103hegiras
hejiras1744233hejiras
hemiolas1387063hemiolas
horas86333093__horas
humoral1237973humoral
humors11129633humor_s
immoral1146783immoral
ixoras1337193_ixoras
koras95927113__koras
lemmas10349163lem_mas
lemons84415053lemo_ns
lempiras1243853lempiras
lemures938793lemures
lemurs837253lemur_s
maras75443283__maras
memoirs1136803memoirs
memorial1249503memorial
memorials1346533memorials
memories121214343memories
memorise121411433memorise
memory1338803memor_y
memos95719113memo__s
menorah1247933menorah
menorahs1346543menorahs
mimosas1136753mimosas
moas65545343__mo_as
molas75132093__molas
monas74732153__monas
mora66641273__mora_
morae75831193__morae
moral75533433__moral
morals85324633__morals
morass84614493__morass
moray105423793__moray
morays114613883__morays
mores76249643__mores
morns75527443__morns
mors65950063__mor_s
morts75533563__morts
moxas145014393__moxas
muras75329563__muras
nemas75321573nem__as
pakoras1337473pakoras
pelorias10410583pelorias
pelorus939273pelorus
pelotas9410723pelotas
peroral9314793peroral
preforms1537393preforms
premolar1246633premolar
premolars1345023premolars
premolds1345843premolds
premorse1237553premorse
preoral9312673pre_oral
presorts105311673presorts
pretors9316803pretor_s
preworks17599003preworks
ramadas1039303ramadas
ramblas112710263ramblas
ramona8412413ramona_
ramous8417103ramo_us
ramrods1036583ramrods
rasboras1045893rasboras
razors154711653razor_s
readorns938273readorns
reamers94221083reamer_s
rearms85114653re_arms
rears54739653re_ar_s
reatas64021013re_atas
rebars84019823rebar_s
reboard10310763reboard
reboards1138773reboards
reboils94111713reboils
rebooks134010513rebooks
reboots93512093reboots
rebops10311423rebo_ps
rebore86625643rebor_e
rebored105015883rebored
reborn810016953rebor_n
rebozos1835143rebozos
recoal84117973reco_al
recoals94214623recoals
recoat84024273reco_at
recoats92616643recoats
recocks154711463recocks
recodes102918633recodes
recoils93814873recoils
recoins94019243recoins
recombs1336753recombs
recons84922993reco_ns
recooks134711233recooks
record96117423recor_d
recork126315483recor_k
recoups1188843recoups
recross989833recross
rectors93520513rector_s
recurs83315803recur_s
redears82814453redears
redias74523603re_dias
redocks14409933redocks
redoes74623753redo_es
redons75222183redo_ns
redos65126763redo__s
redouts81411653redouts
redowa1038453redowa_
redoxes15310883redoxes
redraw10269853re_draw
redraws11218473re_draws
reearns749103reearns
refers93921083refer_s
refires104820313refires
refocus1236973refocus
refolds11298953refolds
reforest1139963reforest
reforge11259033reforge
reforges12249333reforges
reform11312703refor_m
reformat1357653reformat
reformats1445713reformats
regards94112563regards
regears83012463regears
reginas85614063reginas
regorge9257833regorge
regorges10238413regorges
regrows11269153regrows
rehears103312773rehears
rehires105016113rehires
reimports1343663reimports
rejoins143111383rejoins
reload7413893relo_ad
reloads8911313reloads
reloan6415693relo_an
reloans7313133reloans
relocks134411293relocks
relooks114010723relooks
remails94714563remails
remains94117893remains
remakes134116173remakes
reman75730153rem__an
remands104914883remands
remans84823003rem_ans
remap95418103rem__ap
remaps105012873rem_aps
remark123512373remar_k
remarry1235193remarry
remates93827103remates
remeets93712413remeets
remelts93511493remelts
remends105013033remends
remerge10148923remerge
remerges111110203remerges
remiges103015473remiges
reminds104614793reminds
remints95117293remints
remises93423483remises
remiss84216353rem_iss
remits85622943rem_its
remixes164313873remixes
remodel1038093remodel
remodels1135663remodels
remolade1147203remolade
remolades1246563remolades
remold93412973remo_ld
remote84222603remo_te
remoter94815973remoter
remotest103310723remotest
remount9512283remount
remounts1036373remounts
remove116115573remo_ve
removed134611313removed
remover124612273remover
removers13449223removers
rems66237723rem___s
remuda936823remuda_
renogram1147953renogram
renograms1246763renograms
renowns10277833renowns
reoils64516873re_oils
reparks13249513reparks
reperks13298093reperks
rephrase1346733rephrase
repolls939053repolls
report85326013repor_t
repos74725793repo__s
reposal939113reposal
reposals1037403reposals
reposes94021263reposes
repots85621003repo_ts
repours9310223repours
repros84216003re_pros
reran57329103re__ran
rerolls739943rerolls
reroofs1037943reroofs
rescores105415693rescores
resedas839123resedas
resoak10311093reso_ak
resoaks1148973resoaks
resods74116303reso_ds
resoles73823653resoles
resorb84914343resor_b
resort65728613resor_t
resows93915353reso_ws
respray1236503respray
resprays1344713resprays
restoral8810983restoral
restorals978073restorals
restores85222983restores
retards85015003retards
retears72814923retears
retinas74819353retinas
retires74726213retires
retools73411023retools
retore67630763retor_e
retorn610923423retor_n
retort66831143retor_t
retotal739843retotal
retotals838463retotals
retral64419743re_tral
retros63820193re_tros
returns79712593returns
reverbs12368863reverbs
reveres103621343reveres
revers94529633rever_s
reverts104715043reverts
revokes144212503revokes
revolts1038893revolts
revotes104716393revotes
rewards114813993rewards
rewarms12439593rewarms
rewears102911033rewears
rewires104717113rewires
reword106321403rewor_d
rewore938030153rewor_e
rework136619783rewor_k
reworn98122193rewor_n
rewrap11127533re_wrap
rewraps12136563re_wraps
rezeros1647453rezeros
rezones163213943rezones
rhetors1038513rhetor_s
rhodoras1244453rhodoras
rigors72813713rigor_s
rimers84522553rimer_s
rimous8311913rimo_us
riojas1335813r_iojas
ristras7311543ristras
roars55622233r__oars
rotas54827723r__otas
rotors64917933rotor_s
rugolas836373rugolas
rugosas844973rugosas
rumbas102512013rum_bas
rumor71011323rumor__
rumored1046643rumored
rumours976363rumours
samaras9312913samaras
samosas939293samosas
semiraw1246053semiraw
senhoras11278283senhoras
senora63216153senora_
senores73218113senores
senors63620783senor_s
serosas7312663serosas
soras55041013__soras
temperas12278233temperas
temporal1246333temporal
temporals1345293temporals
tempuras12295063tempuras
tenors63217753tenor_s
tephras1236283tephras
termors94712773termor_s
terras63516953te_rras
tetras63017613te_tras
toras55540373__toras
tremolos1046043tremolos
tremor84210393tremor__
tremorous1145433tremorous
tumoral938133tumoral
tumors8810603tumor_s
umbras1038633_umbras
unmoral948693unmoral
uremias9249503urem_ias
urethras1174613urethras
womeras1287593womeras
zebras1737853ze_bras

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340273698.12316499.7
3Display Results3693690.1432580.4
 (SQL Overall)1786913698.42221217.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.