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 “princelinesses” with Change Limit: [1] [2] [3] [4] [5]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

201 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
princelinesses189272(None) 
pricklinesses2143632pri_cklinesses
princeliness1653022princeline_s_s
painterlinesses1792013painterlinesses
priestlinesses1652723priestlinesses
brininesses1339004brin___inesses
crunchinesses2052864crunc_hinesses
friendlinesses1852214friendlinesses
gingerlinesses1652684_gingerlinesses
grislinesses1345844gri__slinesses
gristlinesses1444014gri_stlinesses
kindlinesses1744244_kin_dlinesses
kinglinesses1743854_kin_glinesses
livelinesses15145634_li_velinesses
lonelinesses12146344_lon_elinesses
ornerinesses1246574or_n_erinesses
painfulnesses18115144painful_nesses
painlessnesses1546744painlessnesses
paunchinesses2042344paunc_hinesses
pickinesses1996834p_i_c_kinesses
pointednesses1654974pointe_dnesses
preachinesses2043754preac_hinesses
prickliness1943914pri_ckline_s_s
primenesses1548994pri_me__nesses
princeliest1554334princeli_e_s_t
princelings1642574princelin___gs
princesses14206264princ____esses
prissinesses1355974pri__ssinesses
pronenesses1379264pron_e__nesses
saintlinesses1344364sain_tlinesses
sicklinesses1844864_si_cklinesses
sincerenesses1554734_sincerenesses
sprightlinesses2161824sprightlinesses
springinesses16104074sprin__ginesses
timelinesses1445454_ti_melinesses
trickinesses1845234tri_c_kinesses
tricksinesses1962454tri_cksinesses
wifelinesses1844814_wi_felinesses
bitchinesses1943525_bitc_hinesses
braininesses1446555brain___inesses
brainlessnesses1665025brainlessnesses
breezinesses2343945br__eezinesses
briefnesses1644945bri__e_fnesses
brittlenesses1584235bri_ttlenesses
brotherlinesses2071245brotherlinesses
chancinesses1945035chanc__inesses
chillinesses1744985chi__llinesses
churchlinesses2451395churchlinesses
comelinesses1666405__comelinesses
crankinesses1846145cran__kinesses
creepinesses1645255cr__eepinesses
crispinesses1645015cri__spinesses
criticalnesses1853155critical_nesses
crotchetinesses2261085crotchetinesses
cruelnesses1346255cr__uel_nesses
crumblinesses1952895cr_umblinesses
dailinesses1249495dai___linesses
daintinesses1346245dain__tinesses
dinginesses1337475_din__ginesses
drivennesses1643835dri_ve_nnesses
drunkennesses1861855drunke_nnesses
fancinesses1638145_fanc__inesses
ficklenesses2144155_fi_cklenesses
fidgetinesses1851885_fidgetinesses
fierinesses1439245_fi__erinesses
finenesses13310725_fin_e__nesses
finicalnesses1853835_finical_nesses
finickinesses2272065_finickinesses
flintinesses1546325flin__tinesses
friskinesses1944785fri__skinesses
frizzinesses2342945fri__zzinesses
gainfulnesses17124615gainful_nesses
gracilenesses1655165gr_acilenesses
graininesses1346605grain___inesses
greedinesses1446475gr__eedinesses
griminesses14167575gri___minesses
grittinesses1345865gri__ttinesses
grouchinesses1942665grouc_hinesses
growlinesses1644735gr__owlinesses
hillinesses1458505_hi__llinesses
homelinesses1765365__homelinesses
icinesses11310075__i_c__inesses
ickinesses1637185__i_c_kinesses
ineptnesses1396385__in_eptnesses
inertnesses1198725__in_ertnesses
inkinesses1439425__in__kinesses
innernesses1146735__inne_rnesses
intentnesses1277125__intentnesses
invernesses1447035__inve_rnesses
ironicalnesses1662585ironical_nesses
itchinesses1644615__itc_hinesses
jitterinesses2083315_jitterinesses
jointednesses2174025jointe_dnesses
juicinesses2035895jui_c__inesses
kinkinesses1435875_kin__kinesses
knightlinesses2282445knightlinesses
leisurelinesses1581045leisurelinesses
lovelinesses15125335__lovelinesses
lyricalnesses1853105lyri_cal_nesses
maidenlinesses1751975maidenlinesses
manlinesses13910195_man__linesses
mannerlinesses1652405mannerlinesses
mindednesses16105385_minde_dnesses
miserlinesses1554665_miserlinesses
needinesses1258105___needinesses
nicenesses12310355_ni_ce__nesses
oilinesses101512445_oi___linesses
orderlinesses1453395or_derlinesses
ordinarinesses1552355ordin_arinesses
painterliness1572435painterline_s_s
paperinesses1646055p__aperinesses
patchinesses1944365p_atc_hinesses
pepperinesses1653275p_epperinesses
phoninesses1636455phon___inesses
pigginesses1555615p_i__gginesses
pinkishnesses2243985p_inkishnesses
pinknesses1636585p_in___knesses
pipinesses1448605p_i___pinesses
pithinesses1637505p_i__thinesses
pixinesses1937375p_i___xinesses
planenesses1349035plan_e__nesses
planlessnesses1576305planlessnesses
pliablenesses1756075pli_ablenesses
pluckinesses2043995p_luc_kinesses
pointlessnesses1655445pointlessnesses
portlinesses1446995p__ortlinesses
prankishnesses2353205prankishnesses
precisenesses1756285pr_ecisenesses
preppinesses1544885pr__eppinesses
presentnesses1554425pr_esentnesses
prettinesses1447545pr__ettinesses
priceless1336885pri_cel__e_s_s
pricelessly1852475pri_cel__essly
pridefulnesses2053895pridefulnesses
priestesses13104275pri__e_stesses
priestliness1452925priestline_s_s
priggishnesses2152375priggishnesses
primnesses1497805pri____mnesses
princekins1882875princekin____s
princelets1443465princel__e__ts
princelier1443345princeli____er
princeling1544655princelin____g
princesse13264405princ____esse_
privatenesses1855345pri_vatenesses
propernesses1645015pr_ope_rnesses
prosinesses13310865pr___osinesses
provablenesses2154895provablenesses
puninesses121110755p_un___inesses
punkinesses17127225p_un__kinesses
racinesses12313515_r_ac__inesses
raininesses11310495rain___inesses
rancidnesses1544885_ranc_idnesses
randinesses121311205_ran__dinesses
ranginesses121210115_ran__ginesses
raunchinesses1842635raunc_hinesses
recentnesses1465375_r_ecentnesses
reedinesses1259565_r__eedinesses
richnesses1537805_ri_c__hnesses
rifenesses1339955_ri_fe__nesses
riminesses121211425_ri___minesses
ripenesses12310385_ri_pe__nesses
riskinesses1537845_ri__skinesses
ritzinesses2096755_ri__tzinesses
rockinesses1737365_r_oc_kinesses
runninesses11137695_run__ninesses
runtinesses111210965_run__tinesses
scalinesses1339325___scalinesses
shapelinesses1843415_shapelinesses
shininesses1448305shin___inesses
sightlinesses1743865_sightlinesses
sillinesses1169845_si__llinesses
silverinesses1643695_silverinesses
sinfulnesses1546135_sinful_nesses
singlenesses1346105_sin_glenesses
sinlessnesses1157985_sinlessnesses
skinninesses1643475skin__ninesses
slinkinesses1645815slin__kinesses
slipperinesses1851855slipperinesses
spicinesses1547105spi_c__inesses
spininesses1358455spin___inesses
sprucenesses1694615spr_uce__nesses
statelinesses1344235_statelinesses
steelinesses1246725__steelinesses
stickinesses1845085sti_c_kinesses
stinginesses1375965stin__ginesses
stringinesses14124545strin__ginesses
tininesses10311165_tin___inesses
tinninesses1136865_tin__ninesses
tranquilnesses2352165tranquilnesses
trendinesses1346325tren__dinesses
tritenesses11710395tri_te__nesses
unholinesses1544915__unholinesses
unkindlinesses1952565unkin_dlinesses
unlikelinesses1852635unlikelinesses
unlovelinesses1752465unlovelinesses
unrulinesses1245815__unrulinesses
untimelinesses16103185untimelinesses
whininesses1746195whin___inesses
wilinesses131911095_wi___linesses
windinesses1557815_win__dinesses
wintrinesses1555775_win_trinesses

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 Filter178691950240.343520965.0
2DLD Change Limit950242017.58012536.1
3Display Results2012010.1401435.7
 (SQL Overall)1786912018.06322161.9
 
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.