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

171 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
careerer103858(None) 
careener1039321careener
careered1139491careered
careerers1137241careerers
barterer102711632barterer
caperer113013402ca_perer
careened1139192careened
careeners1138532careeners
career85822242car_e_er
careers95218782career_s
carefree1346342carefree
caresser1038802caresser
caterer92815942ca_terer
charterer14197322charterer
cheerer123511752c_heerer
creeper11339972c_reeper
adherer1137563_adherer
alterer72713993_alterer
armorer9259903_armorer
banterer102811773banterer
barbered13259543barbered
barkeeper1742933barkeeper
barrener1038333barrener
bartered113113013bartered
barterers11269633barterers
batterer102713213batterer
borderer1168103borderer
breeder103210043_breeder
calender1138273calender
calenderer1342983calenderer
cambered15129003cambered
cameleer1246033cameleer
canceler12238913canceler
cancered132411553cancered
cankered153010223cankered
cantered113415983cantered
capered123014043ca_pered
caperers122611723ca_perers
capturer1246093capturer
carburet12411113carburet
carceral1247193carceral
carder94524183car__der
carders104820353carder_s
careen84119493car_e_en
careens94514703caree_ns
careering12311203careering
careerism1345623careerism
careerist1148793careerist
caregiver1542713caregiver
carer74942333ca___rer
carers85133963car_er_s
caressed1139163caressed
caressers1137433caressers
caresses10314063caresses
caretaker1545083caretaker
carfare12310073carfare_
carfares13310323carfares
carmaker1637303carmaker
caroler93816753car_oler
caroller1039203caroller
carouser1068843carouser
carpenter1346493carpenter
carper104923633car__per
carpers114521253carper_s
carpeted1338943carpeted
carrel84718633car__rel
carrier93619583car_rier
carter84932273car__ter
carters95327253carter_s
carver114420143car__ver
carvers124817533carver_s
casebearer1452603casebearer
catered103117773ca_tered
caterers102814403ca_terers
catheter1338153catheter
chafferer20133923chafferer
chamferer19154693chamferer
chartered15158393chartered
charterers15146053charterers
chatterer14196843chatterer
cheeper143610743c_heeper
cheered133713293c_heered
cheerers13319543c_heerers
cheerier1348003c_heerier
cipherer1545573cipherer
clamberer15185273clamberer
clatterer11186983clatterer
clearer93710823c_learer
cleverer1334563cleverer
coherer122912783c_oherer
cornered11311133cornered
coverer123113523c_overer
cratered1149683cratered
creamer113714083c_reamer
creaser94415723c_reaser
creeled104012013c_reeled
creeped12329713c_reeped
creepers12318623c_reepers
creepier1236253c_reepier
creese84014333c_reese_
creeses93914623c_reeses
crepier1139733c_repier
crueler939023c_rueler
cumberer14266993cumberer
curseder1145343curseder
dapperer1335763dapperer
darkener1335993darkener
darneder1033983darneder
eagerer8248823ea_gerer
falterer11239853falterer
freezer19348523_freezer
gardener1037103gardener
garnered10247113garnered
gartered10319583gartered
gatherer12147903gatherer
greener83111713_greener
greeter82812673_greeter
hammerer15278143hammerer
hamperer15379093hamperer
hankerer15248233hankerer
harborer1348053harborer
hardener1238883hardener
harkener1537573harkener
jabberer1944023jabberer
jeerer13389933__jeerer
larcener1036493larcener
lateener835763lateener
latherer111310443latherer
laveered1235253laveered
marketer1437383marketer
marrer83716673mar__rer
murderer1145263murderer
orderer8127943_orderer
palterer102411273palterer
pamperer14228333pamperer
panderer112210913panderer
paperer113111903pa_perer
parcener1238473parcener
parleyer1335623parleyer
parterre1036983parterre
patterer103112173patterer
preener93114833_preener
quarterer18145713quarterer
queerer16106503_queerer
rarefier1135353rarefier
rearer64928913__rearer
reefer93314363__reefer
reeker103715593__reeker
reeler63822573__reeler
reverer103815833__reverer
scamperer1544623scamperer
scareder1135783scar_eder
scarpered1435103scarpered
scatterer11186293scatterer
screener1037563screener
sheerer103813843_sheerer
sneerer73512313_sneerer
sorcerer1036433sorcerer
steerer73113633_steerer
streeker12206633streeker
tamperer12248893tamperer
taperer92511793ta_perer
unreeler8127293unreeler
veneerer1145033veneerer
verderer1245373verderer
wagerer11328493wa_gerer
wanderer122210123wanderer
warrener1136913warrener
waterer103314073wa_terer
waverer13319523wa_verer
yammerer15225483yammerer

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.1561145455.1
2DLD Change Limit1461621717.72018932.9
3Display Results1711710.0602850.0
 (SQL Overall)1786911717.93622516.5
 
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.