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

163 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
cripe9552114(None) 
crape96128441crape
crepe95520721crepe
crime94822691crime
cripes105120871cripes
gripe84622961gripe
ripe66038921_ripe
tripe75425381tripe
arise56436432arise
bribe94820782bribe
bride86425532bride
brie65837902bri_e
brine75132272brine
cape87242782c_ape
caribe103416752caribe
cepe84926652c_epe
ceriph1398462ceriph
cerise84822042cerise
cerite84724872cerite
chape125221142chape
chide115321012chide
chile105626892chile
chime125322592chime
chine105231722chine
chip116726422chip_
chips125721252chips
chive135117622chive
cine66242942c_ine
cire65836372c_ire
cite65640342c_ite
clepe94617382clepe
clime95720892clime
cline76428532cline
clip86924002clip_
clips96018302clips
clipt96324272clipt
cope86847382c_ope
coupe96023482coupe
crake114823522crake
crane75331602crane
crap85731842crap_
craped116120522craped
crapes104727692crapes
craps95328642craps
crate76537402crate
crave105626312crave
craze165221462craze
creep95218102creep
creme94319322creme
creped114115702creped
crepes105419342crepes
crepey135110932crepey
crept95125892crept
crepy124812702crepy
crib86323582cri_b
cribs94516752cribs
crick135118752crick
cried84624282cried
crier74724462crier
cries75438402cries
crikey15317782crikey
crimes105521582crimes
crimp115615802crimp
crimped143910762crimped
crimper136510422crimper
crimple13408692crimple
crimps124613452crimps
crimpy15489392crimpy
cringe93515482cringe
cripple13378582cripple
cris66233432cri_s
crises84529432crises
crisp95014622crisp
crisped124010102crisped
crispen11348202crispen
crisper113511052crisper
crisps104411512crisps
crispy13478562crispy
crit65743712cri_t
crits75527572crits
crone75231332crone
crop87628632crop_
crops96125232crops
crore74922872crore
croupe105114432croupe
croze164719452croze
crude86018572crude
cruise84314042cruise
cruse75726102cruse
crypt123715232crypt
curiae84518372curiae
curie74533042curi_e
curite85222942curite
drape85319632drape
drip76223952drip_
drips85417232drips
dript86923872dript
drive95318002drive
drupe85012992drupe
frise85322452frise
grape84824662grape
gride75223582gride
grime85021322grime
grip76127022grip_
griped104114712griped
griper94114612griper
gripes94619872gripes
gripey124111202gripey
grippe115310322grippe
grips85520132grips
gript85126172gript
gripy115115252gripy
grope84821612grope
lipe66839732_lipe
pipe86434432_pipe
price93725412price
pride84724732pride
prime96525602prime
prise74632612prise
prize164718942prize
rape65041632_rape
rice64942912_rice
ride55945132_ride
rife74632322_rife
rile45650532_rile
rime65138882_rime
rip56851302_rip_
riped85226432_riped
ripen75619262_ripen
riper74328402_riper
ripes75435772_ripes
rips66237432_rips
rise45945232_rise
rite45849452_rite
rive75537722_rive
rope65542912_rope
scrape105917572scrape
scribe104613532scribe
scrip96619192scrip_
scrips105316032scrips
script105717902script
scrive115414942scrive
sipe67341042_sipe
slipe75626132slipe
snipe75320572snipe
stipe76523372stipe
stripe85822442stripe
swipe105217082swipe
tribe74420272tribe
trice75127492trice
trike95320162trike
trine54734602trine
trip66830392trip_
tripes85324872tripes
triple84215922triple
trips74923362trips
trite54730032trite
trope75725802trope
unripe82012092unripe
urine55026602urine
wipe94830282_wipe
write85522832write
yipe96722182_yipe

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 Filter178691538000.860207780.2
2DLD Change Limit538001631.70031647.1
3Display Results1631630.0503260.0
 (SQL Overall)1786911632.61068464.0
 
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.