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

176 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
pomps11531619(None) 
comps115526051comps
pimps114616981pimps
pomes94833931pomes
pomos95321581pomos
pomp106225461pomp_
poms87037741pom_s
poops94422411poops
pops86340951po_ps
pumps115520601pumps
romps94617541romps
amps86230342_amps
bombs115818822bombs
bops86037982bo_ps
bumps115921142bumps
camps116330262camps
chomps155112222chomps
clomps125212232clomps
comas95833002comas
combs116122962combs
comes97246992comes
comp106731252comp_
compas125817062compas
compo115318572compo
compos124818802compos
compt116328222compt
compts125216652compts
coops96229642coops
cops86751372co_ps
corps95927042corps
coups95522472coups
damps105220412damps
domes85735562domes
doms76239572dom_s
dorps85419222dorps
dumps105220102dumps
fops96532682fo_ps
gamps105323712gamps
gimps105915202gimps
goops86620962goops
gorps85316992gorps
hemps126917332hemps
homes106938812homes
homos105921782homos
hoops105621072hoops
hops97942632ho_ps
humps126322802humps
imps86221122_imps
jumps165116492jumps
kemps135012522kemps
kops107031292ko_ps
lamps95624832lamps
limps95522672limps
loops75723962loops
lops66043352lo_ps
loups75319622loups
lumps95624982lumps
momes95134472momes
moms86539482mom_s
momus96116112momus
mops85940132mo_ps
mumps115619102mumps
nomas74726412nomas
nomes74933122nomes
nomos75919742nomos
noms65636402nom_s
oms56337512_om_s
oomph1236972oomph
oomphs1344722oomphs
oops65232672_oops
ops56641252_o_ps
palps94719562palps
pampa114913422pampa
pampas124913992pampas
pams85641762pam_s
paps86443452p_aps
peeps95822362peeps
peps85134512p_eps
perps95521482perps
pimas94725102pimas
pimp106024902pimp_
pips85837132p_ips
plops95920332plops
plumps124612612plumps
pocks135022962pocks
pods76540152po_ds
poems95715552poems
poets76024442poets
pois66539042po_is
pokes116133012pokes
poles75351002poles
polis74731162polis
polls74627722polls
polos76129912polos
pols66044562po_ls
polyps13479762polyps
polys105718762polys
pom78249912pom__
pome85636692pom_e
pommy14449862pommy
pomo85828452pom_o
pompom1436492pompom
pompoms1535332pompoms
pompon1238942pompon
pompons1338552pompons
pompous1338062pompous
ponds85323402ponds
pones74547042pones
pongs85526342pongs
pons65850602po_ns
poods85124752poods
poofs105222792poofs
poohs103915712poohs
pools74427702pools
poons75430972poons
poop86532812poop_
poos65949112po_os
pop76252252po_p_
pope85535612po_pe
popes95933812popes
poppa8409892poppa
poppas93710712poppas
poppy114813192poppy
popsy125713402po_psy
pores75849032pores
porks115124142porks
porns75527342porns
ports75934592ports
poses74642762poses
posts75228782posts
pots66452362po_ts
poufs105616062poufs
pours74623182pours
pouts75530322pouts
pows95537662po_ws
poxes145325722poxes
preps96220692preps
primps124711822primps
promos105116422promos
prompt12313012prompt
prompts1337472prompts
proms95426412prom_s
props95726882props
pulps95116482pulps
pumas95121562pumas
pump105726852pump_
pups86032232p_ups
ramps96224632ramps
romp85926572romp_
roms67038962rom_s
roups75118902roups
rumps95922292rumps
samps96124672samps
simps94719762simps
soaps75120712soaps
somas76030372somas
soms66239372som_s
sops65244562so_ps
soups75322942soups
stomps105612832stomps
sumps95023432sumps
tamps95524082tamps
temps95417132temps
tombs97818732tombs
tomes76037382tomes
toms68343492tom_s
tops66248122to_ps
tromps104911702tromps
tumps95420792tumps
umps85721942_umps
vamps125415482vamps
whomps16457602whomps
wimps125213802wimps
wombs125813342wombs
woops104917522woops
wops96634152wo_ps

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.296603685.8
2DLD Change Limit538001761.75030742.9
3Display Results1761760.0463826.1
 (SQL Overall)1786911762.09285416.3
 
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.