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

225 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
certain9261221(None) 
ceratin93020161ceratin
curtain9319791curtain
pertain92714961pertain
ascertain1144232ascertain
captain112111062captain
centai84814782centai_
ceratins102818732ceratins
certainer1146192certainer
certainly1443152certainly
certainty1443192certainty
contain9315832contain
cortin82423152cort_in
creatin93618132creatin
cretin82917912cret_in
curtail9299662curtail
curtains10259702curtains
destain8412082destain
detain74617382de_tain
detrain8412252detrain
keratin113314152keratin
pertains102113422pertains
retain64523282re_tain
retrain7615422retrain
sextain14257102sextain
terrain7410852terrain
tertian7511192tertian
uncertain1146202uncertain
vervain1335562vervain
abstain947253abstain
acetin8314693ace_t_in
aerating92821003aerating
aeration8319933aeration
appertain1345273appertain
ascertains1244263ascertains
attain6311753_attain
bargain1079063bargain
berating113220763berating
berlin83116373ber_lin
berthing14209593berthing
betaine9413783be_taine
brain76229383_br_ain
caftan111710123cafta_n
cain65643913c___ain
calpain11310413calpain
captains121810573captains
captan101613343capta_n
carabin11313213carabin
carbarn1139453carbarn
carlin84421823car_lin
carman103920743carma_n
carotin92216733carotin
cartage10312593cartage
carting104228283cart_ing
carton84522663cart_on
cartoon94114463cartoon
catkin123512383c_atkin
catlin83819083c_atlin
cattail939183cattail
cedarn9408443ce_darn
cental84420963centa_l
centals94317053centals
centare93113703centare
centas85020703centa_s
centaur935783centaur
centavo1245103centavo
centric11312403centric
centring112112953centring
cephalin1577983cephalin
ceramic1339823ceramic
cerate84829463cer_ate
cerated103922473cerated
cerates95428253cerates
ceratoid1149923ceratoid
cercal10314123cerca_l
cercaria1246963cercaria
cercarian1346233cercarian
cerci93716393cer_ci_
cercis104614493cer_cis
cereal8315833cerea_l
cereals9313173cereals
ceria75125353cer__ia
cerias83321983ceria_s
ceric94023093cer__ic
cering94522533cer__ing
cerotic11415063cerotic
certainest1248863certainest
certes84623083cert_es
certify1546243certify
cerumen1147763cerumen
cervid1239323cer_vid
cervine122610803cer_vine
cervix1865163cer_vix
cesta75419483cesta__
cestas85018543cesta_s
cesti75217423cest_i_
cestoi84511953cestoi_
cestoid104011673cestoid
cetane8315283ce_tane
chain105723673c__hain
chieftain1752643chieftain
chitin113114963chit_in
chitlin12269283chitlin
citrin82615413c_itrin
cocain101315013c_ocain
contains10316533contains
corban10314693corba_n
cordwain1444413cordwain
corsair937633corsair
cortina91915973cort_ina
cortins92421333cort_ins
cotan71521783c_ota_n
crating103725203c_rating
craton84517193c_raton
creatine103417413creatine
creating113921953creating
creatins103617513creatins
creation102816513creation
cremains1238693cremains
cretic102816283cret_ic
cretins93216423cret_ins
curating11314293curating
curran8312023curra_n
curtails10318243curtails
curtained1265503curtained
curtal83914543curta_l
curtals93111623curtals
curtate9312643curtate
cutin75022783c_ut_in
cystein1246053cystein
deltaic1037023deltaic
dentin73919573dent_in
deraign936573der_aign
derail74218813der_ail
derating103222283derating
destains9311813destains
detail74516433de_tail
detains83716093de_tains
detrains9411763detrains
dextrin1587543dextrin
distain8313783distain
drain65222893_dr_ain
elain55324703_e_lain
entail61114343_entail
entertain947863entertain
entrain7313073_entrain
estrin6315923_estrin
etamin81311853_e_tamin
gelatin83514733gelatin
gentian8310103gentian
german9611983germa_n
grain65126253_gr_ain
gratin74520583_gratin
hematin121516023hematin
herein93717793her_ein
hermai118912863hermai_
heroin94420593her_oin
jerkin17258113jer_kin
keratins122313483keratins
lectin82515013lect_in
leptin82512333lept_in
martian93514683martian
martin84122523mart_in
merlin83916683mer_lin
mermaid1297853mermaid
merman10513863merma_n
mortmain1244573mortmain
murrain937763murrain
obtain839183_obtain
oestrin7312243oestrin
ordain7810403_ordain
overlain112112443overlain
overthin1438533overthin
overtrain1259783overtrain
partan83820563parta_n
pearmain1245833pearmain
pectin102615533pect_in
permian112612283permian
pertained1238503pertained
pretrain10310923pretrain
rain46251733__r_ain
reattain846733reattain
redtail858713redtail
refrain10310043refrain
regain74517763re_gain
remain85919863re_main
reobtain1044623reobtain
reordain9135573reordain
reran57329103rer_a_n
restrain8311703restrain
retail65522073re_tail
retains74522253re_tains
retrains8314533retrains
seatrain847923seatrain
seitan62613233seita_n
serai56830163ser_ai_
serail64222673ser_ail
serais64326133ser_ais
serein63318463ser_ein
sericin9312843sericin
serin55434443ser__in
sextains15246813sextains
sextan13389643sexta_n
sprain83614863spr_ain
stain55727943__stain
strain64919573str_ain
sustain738773sustain
tain45548073___tain
tartan64217513tarta_n
tearstain943433tearstain
terai53525483ter_ai_
terais64023513ter_ais
terrains8410323terrains
terrapin1046203terrapin
tertial7313863tertial
tertians839103tertians
train56529113_tr_ain
ventail10310453ventail
veratrin1147703veratrin
verdin103113023ver_din
vermian12329713vermian
vermin113414523ver_min
vervains1435293vervains
vitrain1038943vitrain
zeatin15412823zeat_in

Search took 7 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.406440125.6
2DLD Change Limit1340272256.22021547.7
3Display Results2252250.0762960.5
 (SQL Overall)1786912256.70226662.3
 
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.