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

155 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
pimps11461698(None) 
gimps105915201gimps
imps86221121_imps
limps95522671limps
pimas94725101pimas
pimp106024901pimp_
pips85837131pi_ps
pomps115316191pomps
primps124711821primps
pumps115520601pumps
simps94719761simps
wimps125213801wimps
aims67738182aim_s
amps86230342_amps
bimas95521742bimas
blimps12588152blimps
bumps115921142bumps
camps116330262camps
chimps155713662chimps
comps115526052comps
crimps124613452crimps
damps105220412damps
dimes85833042dimes
dims75435022dim_s
dips75536912di_ps
dumps105220102dumps
gamps105323712gamps
gimp96124042gimp_
gimpy135212232gimpy
gips75632922gi_ps
hemps126917332hemps
hims95230972him_s
hips96433702hi_ps
humps126322802humps
imp76626972_imp_
impi85415792_impi
impis96213852_impis
jimp155618462jimp_
jimpy195210822jimpy
jumps165116492jumps
kemps135012522kemps
kips106430512ki_ps
lamps95624832lamps
limas75627632limas
limbs96118942limbs
limes75636502limes
limns75718392limns
limos75320812limos
limp88432492limp_
limpa97014462limpa
limpas105513082limpas
limpsy13516842limpsy
lips67141442li_ps
lisps76913912lisps
lumps95624982lumps
mimes95732022mimes
mips85534082mi_ps
mumps115619102mumps
nims66226882nim_s
nips65830922ni_ps
palps94719562palps
pampa114913422pampa
pampas124913992pampas
pams85641762pam_s
paps86443452p_aps
peeps95822362peeps
peps85134512p_eps
perps95521482perps
pians75126962pians
pias66542552pi_as
picas94626522picas
picks135226142picks
pics85633912pi_cs
piers75926332piers
pies66949602pi_es
pigs76634222pi_gs
pikas114218092pikas
pikes115031032pikes
pikis115116392pikis
piles74742612piles
pilis75825202pilis
pills74130972pills
pilus75921062pilus
pima85428652pim_a
pimped134913482pimped
pimple123512962pimple
pimples133012422pimples
pimply15329212pimply
pinas75434452pinas
pines76048862pines
pings85830882pings
pinks115729382pinks
pins65558452pi_ns
pints75936222pints
pinups1037412pinups
pions75826392pions
pious74621272pious
pip78051042pi_p_
pipe86434432pi_pe
pipes96030142pipes
pipy115421512pi_py
pirns76020092pirns
pis56362032pi__s
pisos76021062pisos
piss65033332pi_ss
pitas77427672pitas
piths105817542piths
pits66348742pi_ts
pixes144323172pixes
plops95920332plops
plumps124612612plumps
pomes94833932pomes
pomos95321582pomos
pomp106225462pomp_
poms87037742pom_s
poops94422412poops
pops86340952p_ops
preps96220692preps
primas104418102primas
primes104225262primes
primos104514422primos
primp115615922primp_
prims95425932prim_s
primus103712172primus
props95726882props
pulps95116482pulps
pumas95121562pumas
pump105726852pump_
pups86032232p_ups
ramps96224632ramps
rimes75634542rimes
rims65936302rim_s
rips66237432ri_ps
romps94617542romps
rumps95922292rumps
samps96124672samps
simas75727552simas
simp85228772simp_
sims65737172sim_s
sips65740102si_ps
skimps14488042skimps
sumps95023432sumps
tamps95524082tamps
temps95417132temps
times75630822times
tips66436762ti_ps
tumps95420792tumps
umps85721942_umps
vamps125415482vamps
vims95423312vim_s
wimp115521522wimp_
wimpy155911922wimpy
wisps105214182wisps
yips95226702yi_ps
zips155723792zi_ps

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 Filter178691538000.313570897.8
2DLD Change Limit538001551.56334421.0
3Display Results1551550.0463369.6
 (SQL Overall)1786911551.92292971.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.