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

150 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
crispens1228625(None) 
crispen11348201crispen_
crispers12309431crispers
christens14125412christens
crimpers14318932crimpers
cripes105120872cri_pe_s
crises84529432cris_e_s
crisped124010102crispe_d
crispened1443612crispened
crisper113511052crispe_r
crispest12177372crispest
crisping13319662crisping
crispness1345302crispness
crisps104411512crisp__s
mispens11311072_mispens
ripens85012172_ri_pens
arisen65316793aris_en_
arises65233803aris_e_s
arpens84814823ar__pens
aspens85013353__aspens
brises84927613bris_e_s
briskets14346563briskets
brisses94314313brisse_s
caissons1036283caissons
cerises94722253ceris_e_s
chastens13429183chastens
cheapens15305943cheapens
chickens19267433chickens
chippers173510883chippers
chirpers15358133chirpers
chisels12219103chis_els
chrismons1644003chrismons
christen13106703christen_
cisterns10369573c_isterns
claspers124410913claspers
clippers14368843clippers
copens106119963c__opens
crampons1436643crampons
crapes104727693cr_ape_s
crappers144011023crappers
crases85532313cras_e_s
crashers134013233crashers
crashes124618403crashe_s
cravens124010113cr_avens
creepers12318623creepers
crepes105419343cr_epe_s
crepons1139313cr_epons
crescent12711053crescent
crescents1367543crescents
cresses94219813cresse_s
cressets10309103cressets
cribbers14306443cribbers
crickets16418123crickets
criers83918583cri__ers
cries75438403cri__e_s
crimes105521583cri_me_s
crimmers14298543crimmers
crimped143910763crimpe_d
crimper136510423crimpe_r
crimping15299783crimping
crimples14308963crimples
crimps124613453crimp__s
crimsons1245633crimsons
cringers112511873cringers
cringes103215503cringe_s
cripe95521143cri_pe__
cripplers15314993cripplers
cripples14298403cripples
crisis83716343cris__is
crisp95014623crisp___
crispate1246913crispate
crispening1543873crispening
crisphead1742663crisphead
crispheads1842353crispheads
crispier12297253crispier
crispiest13197423crispiest
crispily1574693crispily
crispiness1444793crispiness
crisply14426523crisp_ly
crispy13478563crisp__y
critters103511323critters
croppers143311483croppers
crosiers103312063crosiers
crossers103912703crossers
crosses94220793crosse_s
croupes114613103croupe_s
cruisers10438273cruis_ers
cruises93514443cruis_e_s
crumpets14335943crumpets
cruppers14317323cruppers
cruses88127713crus_e_s
crusets93811043crus_ets
crushers134010093crushers
crushes124215133crushe_s
cryogens1444723cryogens
cuishes122810823cuishe_s
cuisines1049373cuisines
cuisses9319883cuisse_s
dispels10310503_dispels
dispend11289413_dispend
dispends12308533_dispends
dispense11129783_dispense
drippers13327943drippers
freshens14298313freshens
frisbees13295013frisbees
frisees104411693fris_ees
frises94124273fris_e_s
friskers15337373friskers
friskets15326263friskets
frissons1145043frissons
glistens9366593glistens
graspers11338403graspers
greisens954653greis_ens
gripers104011463gri_pers
gripes94619873gri_pe_s
grippers13358133grippers
grippes124810373grippe_s
griskins1335953griskins
grisons838993gris_ons
gristers94013403gristers
irises64221173iris_e_s
krises105016083kris_e_s
lippens11328533_lippens
lispers94514323_lispers
listens74014133_listens
mispen10312173_mispen_
moistens10268773moistens
orisons7310563oris_ons
pigpens1235503_pigpens
prises84133173pris_e_s
prisons9313223pris_ons
prisses94816713prisse_s
prospers123012263prospers
raspers94415923_raspers
reopens939373_reopens
richens12349733_richens
ripen75619263_ri_pen_
ripes75435773_ri_pe_s
rippers114115033_rippers
risen54621883_ris_en_
risers64624783_ris_ers
rises55244043_ris_e_s
riskers114011993_riskers
scrimpers1554633scrimpers
shippens15316803shippens
triens65417543tri__ens
tripes85324873tri_pe_s
trippers123210163trippers
trippets12357423trippets
whispers16266993whispers

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621508.00018270.3
3Display Results1501500.0632381.0
 (SQL Overall)1786911508.21921741.2
 
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.