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

192 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
prim8513220(None) 
brim85629371brim
grim76929421grim
pram85733491pram
prig75924871prig
prima95019341prima
prime96525601prime
primi95017401primi
primo95017911primo
primp115615921primp
prims95425931prims
prism94820261prism
prom87631701prom
rim56052281_rim
trim65329521trim
aim57858222_aim
aria46245422aria
arid57642722arid
aril45843022aril
arm58449622ar_m
arum66129032arum
brie65837902brie
brig76528032brig
brims94721622brims
brin67038192brin
brio65432492brio
bris65539612bris
brit66350152brit
cram85635492cram
crib86323582crib
crime94822692crime
crimp115615802crimp
cris66233432cris
crit65743712crit
dim68146502_dim
dram75832002dram
drib76823262drib
drip76223952drip
drum76521592drum
firm96026462firm
frig85424502frig
frit77044472frit
friz166324342friz
from96923922from
glim76026352glim
gram77034582gram
grid65829622grid
grig65424772grig
grime85021322grime
grimy114312602grimy
grin55733722grin
grip76127022grip
grit55247242grit
grum75625082grum
him86247672_him
irid55927182irid
iris45732552iris
kris86423612kris
maim85831492maim
mim76048432_mim
nim57142962_nim
oxim131114052oxim
paid75737492paid
paik105726802paik
pail66141832pail
pain65647242pain
pair66031512pair
palm85331362palm
pam77858392p_am
paris75145942paris
pein65834942pein
peri65636972peri_
peril75425952peril
peris75537072peris
perm85834632perm
phi86524202phi_
phis95724902phis
phiz186718842phiz
pi48145372p_i_
pia56848042p_ia
pic76046832p_ic
pie55457412p_ie
pig65744982p_ig
pima85428662p_ima
pimp106024912p_imp
pin57066732p_in
pip78051052p_ip
pirn67128382pirn
pis56362042p_is
pit56471932p_it
piu56639552p_iu
pix126437942p_ix
plie65127392plie
plum85122102plum
poem86225772poem
poi57244662poi_
pois66539042pois
pom78249912p_om
porism104518062porism
praam94815612praam
prams96125512prams
prao66229022prao
prat65952042prat
prau66529472prau
pray96331532pray
pree67044732pree
prelim10311432prelim
prep86427672prep
prex135722972prex
prey96228482prey
prez156126312prez
price93725412price
prick134317502prick
pricy124814562pricy
pride84724742pride
pried84426862pried
prier75027762prier
pries74339532pries
prigs85219702prigs
prill74117942prill
primal104014622primal
primas104418102primas
primed115118912primed
primer105118682primer
primes104225262primes
primly13439622primly
primos104514422primos
primps124711822primps
primus103712172primus
prink114719672prink
print74837462print
prion75119992prion
prior74316172prior
prise74632612prise
prisms104915502prisms
priss74623892priss
privy13439832privy
prize164718942prize
pro55837262pr_o
proa66229962proa
prod76129502prod
proem94818272proem
prof96134662prof
prog75729002prog
promo95620002promo
proms95426412proms
prop85932812prop
pros65742782pros
prow97030382prow
pry85728052pr_y
psi56621622psi_
psis68120342psis
puri65931442puri_
purin75527592purin
puris75332022puris
purism104715062purism
pyic116915822pyic
pyin96823232pyin
pyric123815072pyric
ram56867272_ram
rem56150042_rem
ria36745512_ria
rib56848042_rib
rid46754642_rid
rif65951572_rif
rig46748132_rig
rime65138892_rime
rims65936312_rims
rimy96621292_rimy
rin36663192_rin
rip56851312_rip
rom59855632_rom
rum56644642_rum
scrim95419742scrim
shim95827862shim
sim56553152_sim
skim105322522skim
slim66631962slim
sprig85617742sprig
sprit76736402sprit
sri35634002sri_
sris45434152sris
swim96221402swim
tram67034552tram
trig55528162trig
trims75021472trims
trio45233342trio
trip66830392trip
uric63624942uric
vim87437032_vim
whim126220532whim
writ75537912writ

Search took 2 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 Filter178691298720.280638182.1
2DLD Change Limit298721920.78338150.7
3Display Results1921920.0464173.9
 (SQL Overall)1786911921.109161128.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.