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 “cripes” with Change Limit: [1] [2]

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

168 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
cripes10512087(None) 
crapes104727691crapes
crepes105419341crepes
cries75438401cri_es
crimes105521581crimes
cripe95521141cripe_
crises84529431crises
gripes94619871gripes
ripes75435771_ripes
tripes85324871tripes
arises65233802arises
bribes105918532bribes
brides94423512brides
bries74942152bri_es
brines85028852brines
brises84927612brises
capes95441922c_apes
caribes113715642caribes
carices114220952carices
caries85147622cari_es
cepes94424462c_epes
ceriphs1484752ceriphs
cerises94722252cerises
cerites94823432cerites
chapes135421872chapes
chides124620472chides
chiles115425302chiles
chimes134922572chimes
chines115029172chines
chips125721252chip_s
chives144317592chives
cines75239682c_ines
cires74932912c_ires
cites74435582c_ites
clepes104214622clepes
climes104720002climes
clines84926042clines
clips96018302clip_s
copes97747102c_opes
copies104130302copies
coupes105022522coupes
crakes124921812crakes
cranes84330752cranes
crape96128442crape_
craped116120522craped
craps95328642crap_s
crases85532312crases
crates85736052crates
craves115825392craves
crazes174720132crazes
creeps104213622creeps
cremes104517992cremes
crepe95520722crepe_
creped114115702creped
crepey135110932crepey
cribs94516742cri_bs
cricks144316052cricks
cried84624282cri_ed
crier74724462cri_er
criers83918582criers
crikey15317782crikey
crime94822692crime_
crimped143910762crimped
crimper136510422crimper
crimpers14318932crimpers
crimples14308962crimples
crimps124613452crimps
cringes103215502cringes
cripples14298402cripples
cris66233432cri__s
crisis83716342crisis
crisped124010102crisped
crispen11348202crispen
crispens12286252crispens
crisper113511052crisper
crispers12309432crispers
crispest12177372crispest
crisps104411512crisps
crits75527572cri_ts
crones84729242crones
crops96125232crop_s
crores86121162crores
croupes114613102croupes
crozes174417662crozes
cruces105117542cruces
crudes96218622crudes
cruises93514442cruises
cruses88127712cruses
cruxes154911562cruxes
crypts13397742crypts
curies84934022curi_es
curites93919862curites
drapes95419652drapes
dries64733672dri_es
drips85417232drip_s
drives105117112drives
drupes94912652drupes
fries85535602fri_es
friges104116482friges
frises94124272frises
frites94922482frites
frizes184015462frizes
grapes95123122grapes
grides84422362grides
grimes94619032grimes
gripe84622962gripe_
griped104114712griped
griper94114612griper
gripers104011462gripers
gripey124111202gripey
grippes124810372grippes
grips85520132grip_s
gropes95220402gropes
irides74519122irides
irises64221172irises
krises105016082krises
pipes96030142_pipes
prices104524542prices
prides94324182prides
pries74339532pri_es
primes104225262primes
prises84133172prises
prizes173819812prizes
rapes75740722_rapes
ribes75530172_ribes
rices75536152_rices
rides66140812_rides
riles55343642_riles
rimes75634542_rimes
ripe66038922_ripe_
riped85226432_riped
ripen75619262_ripen
ripens85012172_ripens
riper74328402_riper
ripest84317932_ripest
rips66237432_rip_s
rises55244042_rises
rites54442552_rites
rives85336002_rives
ropes75940062_ropes
scrapes116217662scrapes
scribes113713202scribes
scries85226822scri_es
scrips105316032scrip_s
scripts11509372scripts
scrives124414272scrives
sipes76036952_sipes
slipes84921412slipes
snipes83917392snipes
stipes84524052stipes
stripes95320572stripes
swipes114114332swipes
trapes85024462trapes
tribes85119022tribes
trices84826332trices
tries55742812tri_es
trikes105419492trikes
trines64132562trines
tripe75425382tripe_
triples94616872triples
tripos84014922tripos
trips74923362trip_s
tropes84824352tropes
urines64724122urines
wipes104827082_wipes
wries85827742wri_es
writes94420332writes
yipes106017842_yipes

Search took 3 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 Filter178691825510.1401276364.3
2DLD Change Limit825511682.58031996.5
3Display Results1681680.0463652.2
 (SQL Overall)1786911682.76664602.7
 
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.