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

213 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
criminy1426845(None) 
crimine112413471crimine
crimini11258881crimini
acrimony1543562acrimony
chiming153311832chiming
cremini11229062cremini
criminal1248302criminal
criminis12257302criminis
crimping15299782crimping
crimpy15489392crim_py
grimily1336522grimily
griming113612492griming
jiminy1836272_jiminy
primine113214822primine
priming123417372priming
riming93322222_riming
acridine1139553acridine
acridity1446913acridity
agrimony1442343agrimony
aiming94320843_aiming
alimony1236013alimony
aridity11510113aridity
arising83619973arising
arming94719803ar_ming
becriming1646363becriming
beriming13310463beriming
brainy114815643br_ainy
bribing123111043bribing
brimming15196623brimming
brining103216473brining
briny104719663br__iny
briony1149043bri_ony
bromin102615693bromin_
bromine112915243bromine
bromins112513783bromins
caiman103615663caiman_
caimans113811783caimans
cairny11557823cai_rny
calming123915973calming
carmine112918483carmine
caroming133312963caroming
catmint11314463catmint
ceiling103416723ceiling
ceremony1544313ceremony
chiding143911593chiding
chimbly1974593chimbly
chimley1785163chimley
chimney1795483chimney
chining133316843chining
chirming16318643chirming
chitin113114963chitin_
chitins122713793chitins
chroming163410723chroming
citify1437443c_itify
citing94220183c_iting
claiming13279303claiming
climbing15205983climbing
coaming123818323coaming
coifing133213893coifing
coiling103723453coiling
coining103920543coining
coming114225453c_oming
comity13312713c_omity
cramming15339433cramming
cramoisy1543703cramoisy
cramping153411853cramping
crampy154710993cram_py
craning103620303craning
cranny114210273cr_anny
craping124018713craping
crating103725203crating
craving134015733craving
crazily2136923crazily
crazing193914583crazing
creamily1536363creamily
creaming133413143creaming
cremains1238693cremains
creminis12208253creminis
creping122913653creping
cretin82917913cretin_
cretins93216423cretins
crewing133212633crewing
cribbing15276843cribbing
crickey18418143crickey
cricking173412653cricking
crikey15317783cri_key
crime94822693crim__e
crimes105521583crim_es
criminally1746193criminally
criminals1346303criminals
criminate1348983criminate
criminous1375323criminous
crimmer133310773crimmer
crimp115615803crim__p
crimped143910763crimped
crimper136510423crimper
crimpier14287323crimpier
crimple13408693crimple
crimpling1645343crimpling
crimps124613453crim_ps
crimson1135643crimson
crimsons1245633crimsons
cringing123311383cringing
crinite9513633crinite
crinkly16387523crinkly
crisic103611843crisi_c
crisis83716343crisi_s
crispily1574693crispily
crisping13319663crisping
crisply14426523crisply
crispy13478563cri_spy
critic103616813criti_c
critics112811093critics
crocine11314153crocine
crony105918673cr__ony
crowing133814763crowing
crucify1744063crucify
crudity1336043crudity
cruising112610153cruising
crumbing15267813crumbing
crumbly16347523crumbly
crumby15408113crum_by
crummy15365893crum_my
crumping15319903crumping
crumply16336093crumply
crusily12199093crusily
crying123612283cr_ying
cuisine9310423cuisine
culming123811183culming
cumin94616973c_umin_
cumins103314933c_umins
cummin1288783cummin_
cummins1358963cummins
dimity12310473_dimity
driving123910713driving
ermine8416923er_mine
firming132811223firming
framing133014793framing
frizing203310873frizing
gliming113310133gliming
grainy103914213gr_ainy
griding103014973griding
grimier103210433grimier
grimly12459933grim_ly
grimy114312603grim__y
griping113012063griping
hominy144511483_hominy
imine75821063__imine
imino74315233__imino
irising83614423irising
jimminy2133373jimminy
limina83514503_limina
liming94021243_liming
maiming122912723maiming
miming114317263_miming
origin7311033origin_
origins8310463origins
pricily142710283pricily
pricing123417343pricing
priding113317543priding
primacy1635603primacy
primary1437703primary
primely1457723primely
primi95017403primi__
primines123013703primines
primings13338143primings
primly13439623prim_ly
primming15268173primming
primping15338893primping
prising103321453prising
privily15207623privily
privity15268313privity
prizing193514683prizing
promine112819443promine
rainy85921083_r_ainy
raisiny10319923raisiny
ramify14268753_ramify
remind94819793_remind
remint85329983_remint
resiny94617363_resiny
ricin74620213_ricin_
ricing94822763_ricing
ricins83618703_ricins
riding84325963_riding
riling74227973_riling
rimier83916273_rimier
rimming123411073_rimming
rimy96621283_rim__y
riping93821613_riping
rising74025883_rising
riving104521423_riving
rosiny94414533_rosiny
rumina83412483_rumina
saimin8313663saimin_
saimins9312113saimins
scribing13238183scribing
scrimpily1842553scrimpily
scrimping1634953scrimping
scrimpy16486133scrim_py
scriving14258763scriving
scrutiny1344773scrutiny
simony1137903_simony
slimily1247713slimily
sliming102913953sliming
timing93619303_timing
tricing103417353tricing
trimly114410893trim_ly
trimming13318653trimming
trining82919213trining
trinity10310843trinity
uridine81311213uridine
vimina11339943_vimina
writing113713893writing

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 Limit1340272136.39320964.6
3Display Results2132130.0762802.6
 (SQL Overall)1786912136.87525991.4
 
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.