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

165 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
crimes10552158(None) 
chimes134922571chimes
climes104720001climes
cremes104517991cremes
cries75438401cri_es
crime94822691crime_
crimps124613451crimps
cripes105120871cripes
crises84529431crises
grimes94619031grimes
primes104225261primes
rimes75634541_rimes
animes84719592animes
arames84622572arames
arises65233802arises
armies85123692armies
becrimes1467072becrimes
berimes115216642berimes
bribes105918532bribes
brides94423512brides
bries74942152bri_es
brims94721622brim_s
brines85028852brines
brises84927612brises
bromes104719762bromes
brumes106417072brumes
cames97047312c_ames
caribes113715642caribes
carices114220952carices
caries85147622cari_es
cerises94722252cerises
cerites94823432cerites
chides124620472chides
chiles115425302chiles
chimbs153910302chimbs
chime125322592chime_
chimed145814832chimed
chimer135517202chimer
chimers144515132chimers
chimps155713662chimps
chines115029172chines
chives144317592chives
chromes142914932chromes
chymes165912152chymes
cimex16119132c_imex
cines75239682c_ines
cires74932912c_ires
cites74435582c_ites
climbs12498722climbs
clime95720892clime_
clines84926042clines
comes97246992c_omes
crakes124921812crakes
crambes1339952crambes
cramps125615562cramps
crams96229152cram_s
cranes84330752cranes
crapes104727692crapes
crases85532312crases
crates85736052crates
craves115825392craves
crazes174720132crazes
creme94319322creme_
crepes105419342crepes
cribs94516742cri_bs
cricks144316052cricks
cried84624282cri_ed
crier74724462cri_er
criers83918582criers
crikey15317782crikey
crimmer133310772crimmer
crimmers14298542crimmers
crimp115615802crim_p
crimped143910762crimped
crimper136510422crimper
crimpers14318932crimpers
crimples14308962crimples
crimpy15489392crimpy
cringes103215502cringes
cripe95521142cripe_
cris66233432cri__s
crisis83716342crisis
crisps104411512crisps
crits75527572cri_ts
crones84729242crones
crores86121162crores
crozes174417662crozes
cruces105117542cruces
crudes96218622crudes
cruises93514442cruises
crumbs12409232crumbs
crumps124514342crumps
cruses88127712cruses
cruxes154911562cruxes
curies84934022curi_es
curites93919862curites
cymes1210118922c_ymes
dimes85833042_dimes
dries64733672dri_es
drives105117112drives
frames115119862frames
fries85535602fri_es
friges104116482friges
frises94124272frises
frites94922482frites
frizes184015462frizes
glimes94717522glimes
grides84422362grides
grime85021322grime_
grimed104714092grimed
gripes94619872gripes
grumes94415552grumes
irides74519122irides
irises64221172irises
krises105016082krises
limes75636502_limes
mimes95732022_mimes
oximes15107422oximes
prices104524542prices
prides94324182prides
pries74339532pri_es
primas104418102primas
prime96525602prime_
primed115118912primed
primer105118682primer
primers114215672primers
primos104514422primos
primps124711822primps
prims95425932prim_s
primus103712172primus
prises84133172prises
prizes173819812prizes
ribes75530172_ribes
rices75536152_rices
rides66140812_rides
riles55343642_riles
rime65138882_rime_
rimed84826372_rimed
rimer75429242_rimer
rimers84522552_rimers
rims65936302_rim_s
ripes75435772_ripes
rises55244042_rises
rites54442552_rites
rives85336002_rives
scribes113713202scribes
scries85226822scri_es
scrimps13517902scrimps
scrims104615932scrim_s
scrives124414272scrives
slimes84722042slimes
stimes85920572stimes
times75630822_times
tribes85119022tribes
trices84826332trices
tries55742812tri_es
trikes105419492trikes
trimer85717152trimer
trimers94615142trimers
trims75021472trim_s
trines64132562trines
tripes85324872tripes
urines64724122urines
wries85827742wri_es
writes94420332writes

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.1101624463.6
2DLD Change Limit825511652.51332849.6
3Display Results1651650.0463587.0
 (SQL Overall)1786911652.66966950.5
 
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.