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

188 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
romps9461754(None) 
comps115526051comps
pomps115316191pomps
ramps96224631ramps
romp85926571romp_
roms67038961rom_s
roups75118901roups
rumps95922291rumps
tromps104911701tromps
amps86230342_amps
aromas81018612aromas
bombs115818822bombs
bops86037982bo_ps
bromes104719762bromes
bromos104213312bromos
bumps115921142bumps
camps116330262camps
chomps155112222chomps
clomps125212232clomps
comas95833002comas
combs116122962combs
comes97246992comes
comp106731252comp_
compas125817062compas
compo115318572compo
compos124818802compos
compt116328222compt
compts125216652compts
coops96229642coops
cops86751372co_ps
corps95927042corps
coups95522472coups
cramps125615562cramps
crimps124613452crimps
crops96125242cro_ps
croups104312552croups
crumps124514342crumps
damps105220412damps
domes85735562domes
doms76239572dom_s
dorps85419222dorps
droops95110962droops
drops85719502dro_ps
dumps105220102dumps
fops96532682fo_ps
frumps13479782frumps
gamps105323712gamps
gimps105915202gimps
goops86620962goops
gorps85316992gorps
gramps114114272gramps
groups94210512groups
grumps114510572grumps
hemps126917332hemps
homes106938822homes
homos105921792homos
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
pimps114616982pimps
pomes94833932pomes
pomos95321582pomos
pomp106225462pomp_
poms87037742pom_s
poops94422412poops
pops86340952po_ps
primps124711822primps
promos105116422promos
prompt12313012prompt
prompts1337472prompts
proms95426412prom_s
props95726882pro_ps
pumps115520602pumps
ramp85934002ramp_
rams65950772ram_s
ramus76418282ramus
raps66247732r_aps
rasps74316662rasps
reaps75626192reaps
remaps105012872remaps
rems66237722rem_s
repps95114342repps
reps65937952r_eps
rhombs13336492rhombs
rimes75634542rimes
rims65936302rim_s
rips66237432r_ips
roads66523622roads
roams74919612roams
roans54926442roans
roars55622242roars
robes75133302robes
robs65837872ro_bs
rocks114626412rocks
rocs65533662ro_cs
rodes614039082rodes
rods56442062ro_ds
roes45954142ro_es
roils54826792roils
roles56747982roles
rolfs84817122rolfs
rolls55326232rolls
rom59855632rom__
roman75424822roman
romans84620242romans
romeo73719702romeo
romeos84013172romeos
romped114513652romped
romper104213682romper
rompers113412242rompers
rompish1436692rompish
roods65125282roods
roofs85321152roofs
rooks95325042rooks
rooms75324682rooms
roots55933672roots
rope65542912ro_pe
ropes75940062ropes
ropy96323412ro_py
roses56445772roses
rotas54827722rotas
rotes56143902rotes
rotis56327062rotis
rotls55620162rotls
rotos56027882rotos
rots46454092ro_ts
roues56039352roues
roup66627692roup_
roupy106112712roupy
routs57133412routs
roves84834482roves
rows75941752ro_ws
rump86729082rump_
rumpus10458892rumpus
rums64833472rum_s
samps96124672samps
simps94719762simps
soaps75120712soaps
somas76030372somas
soms66239372som_s
sops65244562so_ps
soups75322942soups
stomps105612832stomps
sumps95023432sumps
tamps95524092tamps
temps95417132temps
tombs97818732tombs
tomes76037382tomes
toms68343492tom_s
tops66248122to_ps
tramps105114452tramps
tromp95815802tromp_
trompe105611262trompe
trompes114111622trompes
troops85712782troops
trumps104611882trumps
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.343520965.0
2DLD Change Limit538001881.93627789.3
3Display Results1881880.0632984.1
 (SQL Overall)1786911882.34276298.5
 
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.