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

138 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
coempted153534(None) 
compted143813531co_mpted
coapted123911512co_apted
coedited1237832coedited
coempt12311032coempt__
coempts1335682coempt_s
commuted15288982commuted
comped135919872co_mp_ed
competed154113592co_mpeted
computed154110952co_mputed
coopted123710782co_opted
cremated133412962cremated
exempted2044142exempted
tempted12317282_tempted
accepted15105413acce_pted
attempted1442573attempted
benempted1642763benempted
camped134720233c_amp_ed
casemated1446953casemated
cemented1338373c_emented
cerated103922473c_erated
champed174111483champ_ed
cheated134416353che_ated
cheeped153410593cheep_ed
chelated142610493chelated
chested133811683che_sted
chomped17329773chomp_ed
chumped17379493chump_ed
clamped144012043clamp_ed
cleated103417853cle_ated
clefted13326763cle_fted
cleped115114123cle_p_ed
clomped14398973clomp_ed
clumped143610663clump_ed
coacted123611613co_acted
coadapted1543163coadapted
coasted104015963co_asted
coated94927043co__ated
coemploy1743323coemploy
coemployed2042683coemployed
coempting1636073coempting
coenacted1445803coenacted
coequated2144823coequated
coerced1238583coe_rced
coerected1447643coerected
coesite9713623coesite_
coesites101313093coesites
coexerted1944763coexerted
coexisted1944153coexisted
coextend1842483coe_xtend
cohosted1436143cohosted
collated113615063collated
colleted113011663colleted
comate104124843co_mate_
comates114123643co_mates
combated1539823combated
combed135516543co_m_bed
commented16129613commented
committed1645723committed
commixed2264743commixed
commoved1844763commoved
communed15338213communed
commute134310443commute_
commuter143010153commuter
commutes143011893commutes
compacted18297363co_mpacted
compared153811823co_mpared
comparted16338423co_mparted
compeer133811553co_mpeer
compel124412893co_mp_el
compend144010303co_mpend
compered153414923co_mpered
compete134716553co_mpete
competes144117243co_mpetes
compiled1537813co_mpiled
completed162810273co_mpleted
complex2037243co_mplex
complied1539683co_mplied
comported16319533co_mported
composed154612063co_mposed
composted16378823co_mposted
compote135616463co_mpote_
compotes144716513co_mpotes
compt116328223co_mpt__
compts125216653co_mpt_s
compute134513663co_mpute_
computer144511513co_mputer
computes143914553co_mputes
comte96125473co_m_te_
comtes106222813co_m_tes
confuted1437683confuted
connoted1138863connoted
cooped114821613co_op_ed
coped105036853co__p_ed
copemate1439993copemate_
copemates1549483copemates
copied114618573co__pied
copped135221263co__pped
copter109822013co__pter
corelated12411823corelated
cornuted1137473cornuted
corrupted1444503corrupted
corseted11311473corseted
cosseted1178343cosseted
costed95623123co__sted
coted85033853co___ted
counted103815803co_unted
couped115019313co_up_ed
coupled124312673co_upled
courted103514923co_urted
coveted133011523co_veted
cramped144712183cramp_ed
created104323463cre_ated
credited1238253credited
creeped12329713creep_ed
cremate113816183cremate_
cremates124216003cremates
crenated113013913crenated
creped114115723cre_p_ed
crested103416553cre_sted
crimped143910763crimp_ed
crimpled15366933crimpled
crumped144311223crump_ed
crumpled15296873crumpled
demoted114313543_demoted
emoted94614923__emoted
emptied1297403__emptied
fomented1437803fomented
oersted839563_oersted
opted84914273_o__pted
preempted1644683preempted
prompted1536903prompted
remated103522473_remated
romped114513653ro_mp_ed
temped113912893_temp_ed
templed12278563_templed
tempter11358213_tempter
vomited1337253vo_mited

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 Limit1461621386.61022112.3
3Display Results1381380.0602300.0
 (SQL Overall)1786911387.09325192.6
 
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.